Query - pull past 12 months

  • Thread starter Thread starter Jani
  • Start date Start date
J

Jani

Can't figure this out and I know the answer is probably so simple. I have a
date field, [date entered], and need to pull data for the previous 12 months.
My latest criteria is: =((DateDiff("m","DateEntered",Now())<=12)) in the
criteria row of the Date Entered field. The error message is that the query
is to complicated, etc., etc. What am I doing wrong? Help is appreciated very
much for the second time today. Jani
 
Here's a hint: [date entered] versus "DateEntered"

In one you have the field name in brackets with a space between the words.
In the other you have the field name as a text string without the space.

You need it within the brackets (no "") and the name spelled as it is in the
table.
 
Back
Top