need help with creating reports...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 3 tables:

1 accts OK 2 pa
2 novpd acct
3 decpd acct

I need to compare both months against the ok list and generate the following reports

a) matche
b) OKs not matche
c) monthly accts paid but not on the OK2Pay lis

any and all help would be appreciated
 
I have 3 tables:

1 accts OK 2 pay
2 novpd accts
3 decpd accts
Click to expand...

But... they are all accounts, no? Why not just ONE table of all
Accounts, related one-to-many to a table with a payment date? Storing
data - a month- in a table name (I'm presuming that NovPd are those
accounts paid in November) is simply BAD DESIGN and will get you into
excessive complexity!
I need to compare both months against the ok list and generate the following reports:

a) matches
Click to expand...

Query with an INNER JOIN.
b) OKs not matched
Click to expand...

Use the UNMATCHED QUERY WIZARD.
c) monthly accts paid but not on the OK2Pay list
Click to expand...

Use the UNMATCHED QUERY WIZARD, just in the opposite order.
 
Back
Top