Compare Timestampt to Short Date

[joeserrone]

Hello!
I'm working on a query that that has 2 separate tables as a source. The first table the data is captured by Date and formatted as Short Date, the second table the data is captured by a timestamp.
For the data captured by the timestamp I am using the: VDate: Format([Timestamp],"Short Date") but when I create a query and try to create a property between the Date from the first Table with the VDate of my Timestamp Query I get a Type Mismatch Error.
For some reason I think Access still thinks VDate is a Timestamp, do you guys have any idea how I can get to compare the timestamp with the regular short date

Thanks

 

[Brianwarnock]

Once you use Format you end up with a string, why cannot you just compare the 2 fields, which are presumeably defind as Date/time fields, the display format doesn't matter.

If its just the date part you are interested in comparing then use Datevalue on each field.

Brian