Microsoft Access Query

  Gary Wood 17:20 12 Apr 06
Locked

I am trying to create a query in Access to select records from a table depending on the value in a Date column of the table.

I need the query to select records which have dates between or equal to 01/09/last_yr and 31/07/this_yr.

Can anyone advise how I can do this?

I can get records for the current year or last year using
Year(now())
and
Year(Now())-"1"
but I can't find a way to combine this with the specific dates.

Thanks in advance if you can help.

Gary

This thread is now locked and can not be replied to.

New Google phones UK release date | Pixel XL price, new features, specifications: Pixel X and…

1995-2015: How technology has changed the world in 20 years

This is the future of TV, VR and holograms

iOS 10 troubleshooting tips: Simple fixes for the most common iOS 10 problems, from network…