Query Field = Query Field

[Christine Boissoin]

My query has (2) calculated fields:

Field 1: ApptDateOnly: DateValue([DateTime])
Field 2: EventDateOnly: DateValue([EventDateTime])

I want my query to return only records where these two fields are equal.

When I reference either field name in a a where criteria - it acts like it is a parameter query seeking input.

Any ideas what I'm doing wrong?
Thanks.
CB

[RayMilhon]

I have 1 question in Field 2 you show EventDateOnlyatevalue([EventDateTime]) but in Field 1 you show APPTDATEONLYateValue([DateTime]) Is [DATETIME] the actual field name or should it be APPTDATETIME which would be consistent with Field 2????

[Christine Boissoin]

[DateTime] and [EventDateTime] are the actual field names - I just needed the date value (not including the time).

Christine

[RayMilhon]

Then This is what I would do in the Column in the query have
Eventatevalue([Eventdatetime]) as the Field Value
DateValue([datetime]) as the criteria value

[RayMilhon]

dont know why theat stupid happy face keeps getting into my posts.

[Christine Boissoin]

Worked perfectly - thanks.
CB