Solved Query Just to show when dates match (1 Viewer)

[Number11]

So i have a query that looks at 2 tables one holds the ticket details and the other is when an appointment is booked I wwant the query only to show when appointment dates match in both tabels can that be done?

 

[arnelgp]

Use Inner query on the 2 tables join on date field.

 

[The_Doc_Man]

Arnel's suggestion is correct but remember that if the dates include times, you might need to make your joins with functions to strip the times from the dates. As long as both items are in date format, an INNER JOIN is perfectly legal.