Total of 2 fields in a query

[mr_sd]

I have a duplicate finding query which returns all the bookings that are on the same date at the same time.

It also returns the number of people.

I would like it to only return results where the total number of people is greater than 20. (all duplicate records [nopeople] fields added together)

eg. If I would have 2 bookings on 01/01/05 at 12:00 each with 10 people. The query would not return this

If i would have 2 bookings on 01/01/05 at 12:00 each with 12 people
The query WOULD return this (as 22 is too many)

The query returns duplicates on:
[Date]
[Game1Start]

and also displays various other fields inclusing
[nopeple] which is the field i would like to add.

Thanks in advance

Rich.

 

[MStef]

Hello mr_sd!
Look at "DemoBokinsA97.mdb"

(MStef alias Štef)