Query Criteria

[susan]

what is the query criteria for pulling data from prior
month's records? does it involve the "less than"
character?

 

[Mike Mueller]

: what is the query criteria for pulling data from prior
: month's records? does it involve the "less than"
: character?

Here is what I use for field name in the query, and for
criteria you would use the number of the month, eg <6 would
be January to May, 6 would be June, etc

DatePart("m",[field_name])