Any suggestions on how to simplify queries to identify YTD entries?

[xps35]

I need a query to show complaints only up to today (July 11). I.e. it'd only show entries from 1.1.2011 to 7.11.2011 and 1.1.2012 to 7.11.2012 and 1.1.2013 to 7.13.2013 and so on......

In my humble opinion, that's exactly what my last suggested query does (see post #10). If not, I'd love to hear what the difference is.

[orange]

Is this the logic you are trying to use??

For years between CurrentYear and CurrentYear-10 {Note: between includes endpoints}
get data for Month =1 to CurrentMonth and Day = 1 to CurrentDay

I'm just trying to understand what isn't working and hopefully get a sample of what the desired output would be.

Based on your example database, try this query:

SELECT tblComplaints.ID
, tblComplaints.ComplaintNumber
, tblComplaints.ComplaintDate
FROM tblComplaints
WHERE
 (((Month([tblComplaints]![ComplaintDate]))<=Month(Date())) AND
 ((Day([tblComplaints]![ComplaintDate]))<=Day(Date())) AND
(Year([tblComplaints]![ComplaintDate])>=Year(Date())-10));

[templeowls]

In my humble opinion, that's exactly what my last suggested query does (see post #10). If not, I'd love to hear what the difference is.

You're right!! This worked! Sorry I missed this one.

Thanks for everyone's help!!