I.T. Discussion Community!
marcus welby
-Collapse +Expand
Terms:
Not a client.
-Collapse +Expand
csgPdx
-Collapse +Expand Profile◄╣
      Print This  
Personal Account . . .
csgPdx
-- USA
Rank: Cadet 2nd Year
Send New Private Message Send Message   Add ContactAdd To Friend List Block Member Block Member
Real Name:  marcus welby
Joined: Sep 2007 (8 years ago)
Visits: 10
Member Points16
Primary Role:  Coder
Location:  -- USA

Highlights

Posted within the last 90 days.
New?   Title Created By For...
Nothing New Since Your Last Visit
145
Hits
1. creating flat file from a normalized table w/ QBE
Some years ago I saw a query of a single normaiized table that gave a flat file answer table. Presently, I have file that tracks payments and adjustments to outstanding receivables. A single claim may have many payments (either from insurance companies or patients) and/or adjustments (from contract write-offs to collection write-off). I am needing to show for each claim, in a single row, amounts for each type of payment and adjustments. Of course, I can produce this result in a series of queries. And fortunately, there is a relatively small number of payment and adjustment categories, so this is entirely doable. However, I am interested in the technique, as such, that used a "self-join." I've had no success in searching on the internet, in part, perhaps, because I am not even using the right terminology. Thanks, NK
Posted to MB Topic: QBE & SQL  « Paradox Board
70 days ago

csgPdx

Updated 90 Day Posts: All Types

Updated within last 90 days and not in the new 90 day posts list above.
New?   Title Created By For...
Nothing New Since Your Last Visit
145
Hits
1. creating flat file from a normalized table w/ QBE
Some years ago I saw a query of a single normaiized table that gave a flat file answer table. Presently, I have file that tracks payments and adjustments to outstanding receivables. A single claim may have many payments (either from insurance companies or patients) and/or adjustments (from contract write-offs to collection write-off). I am needing to show for each claim, in a single row, amounts for each type of payment and adjustments. Of course, I can produce this result in a series of queries. And fortunately, there is a relatively small number of payment and adjustment categories, so this is entirely doable. However, I am interested in the technique, as such, that used a "self-join." I've had no success in searching on the internet, in part, perhaps, because I am not even using the right terminology. Thanks, NK
Posted to MB Topic: QBE & SQL  « Paradox Board
70 days ago

csgPdx

Message Boards Activity

2 posts.
More...

Thread 2 of 2
Thread Starter or a Reply (but not last)  Group

csgPdx
creating flat file from a normalized table w/ QBE
Some years ago I saw a query of a single normaiized table that gave a flat file answer table. Presently, I have file that tracks payments and adjustments to outstanding receivables. A single claim may have many payments (either from insurance companies or patients) and/or adjustments (from contract write-offs to collection write-off). I am needing to show for each claim, in a single row, amounts for each type of payment and adjustments. Of course, I can produce this result in a series of queries. And fortunately, there is a relatively small number of payment and adjustment categories, so this is entirely doable. However, I am interested in the technique, as such, that used a "self-join." I've had no success in searching on the internet, in part, perhaps, because I am not even using the right terminology. Thanks, NK
Posted to MB Topic: QBE & SQL « Paradox Board
70 days ago
Nothing New Since Your Last Visit
151
Hits

Corel Paradox / ObjectPAL Coding

Thread 1 of 2
Thread Starter or a Reply (but not last)  Group

csgPdx
Paradox 10 on Windows 7
I seems to have successfully loaded Paradox 10 (from WPO 2002). However, I am having problems in the data model. 1.) The table lables are not entirely readable 2.) Linking tables is doable, except that te screen gets "smudgy." If I drag the DM window down and back up, the image is clear. Loading the windows help program from MS did not work, but I haven't given this much energy and am not sure that I was doing it properly.
Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board
45 months ago
Nothing New Since Your Last Visit
1300
Hits

Corel Paradox / ObjectPAL Coding
-
  Load Time=1 seconds.
 
Print This


-
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


296 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...
Follow PrestwoodBoards on: 


©1995-2015 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech