Access Query that pulls just the last 6 records or Months.

[BNAST32]

I need to write a query that pulls just the last 6 months of information. The last month of infomation is different for each one. Some end on Jan, some end on March. I need to figure out how to write a query that pulls just last 6 months or records.

 

[coyotem78]

Re: Access Query that pulls just the last 6 records or Month

Hiya

You can write the criteria for the field like this:

Between [Enter first month:] and [Enter second month:]

This will prompt the user for the upper and lower bounds for the criteria, thus you can put in the 6 month period you want to extract

Hope that helped

coyotem78