Duplicate Dates in Query

[d_138]

Hello,



I need to make a Query criteria that shows employees that have two reservations scheduled at the same date. What criterion would I use for this? Below is the entire question:

"Now April points out that she is scheduled to depart on two different river trips on May 8th. You need to do some major revisions to next year’s schedule. But first it would help to write a query that lists the river guides who are scheduled to depart on two or more trips on the same day. List each guide’s FirstName, LastName, DepartureDate, and NumberSameDayDepartures for each departure date. Sequence in ascending order by LastName."

Thank you in advance.

[ranman256]

use the query wizard, create a FIND DUPLICATES query.
after its created, edit the query, add a parameter for the date range