Annoying access/sql query problem

[Bantam]

I've got a table that has multiple entries for people going to specific regional camps (there is a camp code field) and some people cancelled their registrations. I have a boolean field that marks if they've registered, then cancelled. When I want to do a query and count how many campers I have, grouped by region, with the cancelled people not included, this **** thing never works. It might or might not count them, if it does it either just ignores my request to filter out the cancelled, or has them grouped by whether they've cancelled or not (75 campers total, 3 cancelled, so it returns 72 and then another line says 3)... it's really annoying and all the queries I've tried give me problems.

I can do stuff like this so easily in MS Access 97, but in 2000 is when it's giving me these problems. What gives?


THanks all

[M Owen]

Let's see the query you're using ...