Query Criteria

  • Thread starter Thread starter susan
  • Start date Start date
S

susan

what is the query criteria for pulling data from prior
month's records? does it involve the "less than"
character?
 
: 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])
 
Back
Top