AR Aging Query

[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}

 

[[MVP] S.Clark]

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.

 

[Gary B]

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

 

[Dale Fye]

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

 

[[MVP] S.Clark]

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