I have a table with dates (WeekOf) for each monday in 2011. I have a query called "qryPOTransReqDate". In this query I have an expression to calculate a monday date depending on another date in the record. Here is the expression:
WeekOf: CDate(IIf([TransactionDate] Is Null,1,DateAdd("d",2-Weekday([TransactionDate]+[PaymentTermsDays]),[TransactionDate]+[PaymentTermsDays])))
When I try to join this query with the Table on the WeekOf field I get the mismatch.
It looks like a real date filed with I run the qryPOTransReqDate query so I don't know why it will not connect.
Thanks for your help