need help with creating reports...

[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

 

[John Vinson]

I have 3 tables:

1 accts OK 2 pay
2 novpd accts
3 decpd accts

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

Query with an INNER JOIN.

b) OKs not matched

Use the UNMATCHED QUERY WIZARD.

c) monthly accts paid but not on the OK2Pay list

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