Find records with matching dates

[not_rich_yet]

I wish to find records from one table whose date matches that in another table. Without putting in the criteria, the query returns records and some dates do match between columns. Thing is, when I attempt to add the criteria
(eg =[Appointment.Date])
it returns no records at all....am I missing something small and silly here or is it me?

Ta,

nry

 

[RV]

Don't use Date for a column name, it's a reserved word in Access.

When you add your criteria and no records are selected despite your expectations, well,
then your criteria could be wrong....

Post what you want to query, specify the datatype of the columns you're using in your criteria to have a better look at it.

RV

 

[not_rich_yet]

Hmm, when I say column name, I mean the field name that I have dragged from the table in the query window: ie Date dragged from appointment table and Date dragged from the cancellation table. I want to show all records where Appointment.Date = Cancellation.Date and based on other working queries I assumed I could just put =[Appointment.Date] as the criteria for the Cancellation Date column....

nry

 

[David R]

And what RV means is that [Date] as a field name causes Access problems. Rename the fields to [CancelDate] or something of that nature.