AR Aging Query

  • Thread starter Thread starter Gary B
  • Start date Start date
G

Gary B

tblCustomers: CustKey(pk); CustNo; CustName

tblCharges: ChrgKey(pk); CustKey(fk); ChrgDate; ChrgAmount

tblPayments: PmtKey(pk); CustKey(fk); PmtDate; PmtAmount

I want to display CustNo, CustName, [Chrgs-Pmts(00 to 30 Days Old)],
[Chrgs-Pmts (31 to 60 Days Old)], etc.

{I am reposting this need because too many unqualified people have responded
and I believe my original post is washed out}
 
What constitutes a qualified person??
I don't know jack about Accounting, so I hope I don't fall under the "un"
category.

And I wouldn't exactly call Steve Schapel, John Spencer, and Ken Snell
"Unqualified", but you're obviously an expert on who's NOT qualified.
Personally, I would do this with some queries, some VBA, and finally a
crosstab query. But don't think I'll say anymore, because I don't want to
get fried by you, too.

Good luck with your problem and finding "qualified" free help.
 
The doctor who responded (Dale) was swaying the thread towards me needing a
many-to-many table to show the applied payments. Steve then agreed with him.

BUT, Steve responded excellently!

As for you S.Clark...

I am looking for pure SQL, nothing Access related, as we connect through Jet

g
 
Gary,

Don't know where you got the idea that I am a doctor. I am a programmer
and Systems Analyst. Although I am no expert on accounting systems, I have
seen my share, and worked on a couple, so I was just stating my observations
of your table structure and of the report you wanted to create. Which you
never did describe very well.

I stand by my observation that whoever gets this report is not going to
understand what it is telling them.

Dale
Developing Solutions
 
Dr. Dale, Dr. Dale, paging Dr. Dale... Code Blue
You're needed in the data corruption recovery room... STAT!
 
Back
Top