Microsoft Access Query

  Gary Wood 17:20 12 Apr 2006
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.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?