Data Type Mis Match when I try to use "any" data type criteria on a working query

[BigD]

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?

[orange]

What exactly are you trying to do - in plain English-- forget the formula for a minute?

[BigD]

I am simply trying to filter the query by quarter and year in the criteria. For example 4 in QtrNextDue and 2013 in YrNextDue (The database is written in .mdb I just have 2010 on my system)

[orange]

Just a guess, but you may have to use more than 1 query.
Seems you have a lot of calculations going on DateAdd DatePart even NextDue is calculated

You may have to get all of your NextDue dates as Dates, then filter by Year, and then filter that by quarter.

As I said, a guess.