I.T. Discussion Community!
marcus welby -Collapse +Expand
-Collapse +Expand
csgPdx
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (2)

Search csgPdx:

Advanced
      Print This  
Personal Account . . .
csgPdx
-- USA
Rank: Cadet 2nd Year



Real Name:  marcus welby
Primary Role:  Coder
Joined: Sep 2007 (9 years ago)
Visits: 16
Member Points20

Highlights

Posted within the last 90 days.
New?   Title Created By For...
Nothing New Since Your Last Visit
814
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
13 months 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
814
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
13 months 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
13 months ago
Nothing New Since Your Last Visit
845
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
55 months ago
Nothing New Since Your Last Visit
1493
Hits

Corel Paradox / ObjectPAL Coding
-
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

1,544 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-2016 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech