DCount frustration in a report

[Pharcyde]

Greetings all!

I'm doing a statistics report, and it all went fine until i got to the very last part - should've expected it really!

Students can pay their fees for our Law course in 3 ways: Grants - from local education authority (LEA), Personal finance - Yourself/Parent, Sponsorship - from Employer, or a combination of Sponsorship and Personal finance.

The query which i'm doing the DCount on has the following relevent fields:
FeesDesc:Method of payment (as above), and FeesNo: 1st/2nd method of payment

i.e - FeesNo=1, FeesDesc=Parent
FeesNo=2, FeesDesc=Sponsor

Not all students have >1 payment method. There are 173 enrolled on the course and the query brings up 203, which means that there are 30 students with >1 payment method.

Me being me though, I cant work it out! This is the formula I'm using to count students who have fees paid by Sponsorship/Personal finance, which adds up to a big, fat 0!

=DCount("[FeesDesc]","qryStuStatsFees","([FeesNo]=2 AND [FeesDesc] In ('Employer','Other Sponsor')) AND ([FeesNo]=1 AND [FeesDesc] In('Yourself','Parent/Guardian')) ")

Is there anyone who can help me on this, its the very last bit to do then I can relax!!!!

Much obliged, LeeBoy

 

[DALeffler]

Can you run a find duplicates query on your many to many table with the criteria in your dcount?

Then use that query as the domain in the dcount...

Doug.

(edited: first solution wouldn't work... sorry!)