I need a little help please. I have a query that is working as long as I do not try to use any criteria to filter the results. Two of the fields are expressions. 1. In the [QtrNextDue] field I use QtrNextDue: DatePart("q",[Next Due]) and in the [YrNextDue] field I use YrNextDue: DatePart("yyyy",[Next Due]) which works great as long as I do not use criteria to filter my results.
This query is a query of a query which works fine. As a little back ground though... [Next Due] is an expression field. NEXT DUE: DateAdd("yyyy",[FREQUENCY],[REVISED]) which also works fine.
So the problem:
In the criteria in the [QtrNextDue] field I use 1, 2, 3, or 4 and I get the data mis-match error. I put a full date and get same error. I make the 1,2,3,4 text "1","2","3", or "4" and still get the error. It doesn't matter if I put an number, date, or text.
Does anyone know what the fix would be?