Query - pull past 12 months

[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

 

[Jerry Whittle]

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.