Query that shows dates near today

[LukeJ Innov]

Hello All,

I am trying to (and failing) build a query that shows me result that are within a month in the past to today. (confusing I know, ill explain)

Simple example: I have a table with a bunch of records on a contract, it basically shows contract start date and contract end date, What I would like to do is build a query that will show me all of the contracts that are within a month of running out.

For instance:

Id	Contract Name	Start date	end date
1	Dan C. Bell Pay as you go	05/09/2012	04/09/2013
2	Luke J. Fox Pay as you go	30/09/2012	29/09/2013
3	Leila P.M. Cortez Pay as you go	11/10/2012	10/10/2013
4	Dean O. Fisher Unlimited Contract	02/09/2012	01/09/2013
5	Pete D. Wizlan 2GB Contract	31/10/2012	30/10/2013
6	Mary I. Jane Unlimited Contract	18/09/2012	17/09/2013
7	Kathy L. Saunders Unlimited Contract	10/09/2012	09/09/2013
8	John M. Barrymore Unlimited Contract	26/11/2012	25/11/2013
9	Liza M. Nelly Pay as you go	22/12/2012	21/12/2013

Now the query should only show dates running out within a month of today (today being 03/09/2013), which would mean it should show records 1, 2, 6 and 7 as they are just about to run out.

Any one help me please!!!



Thanks in advance

Kind regards
Luke

[amrut]

Use criteria for the End Date field in query

Between Date() and DateAdd ("m", 1, Date())

See http://www.techonthenet.com/access/f...te/dateadd.php for use of dateadd function.

[LukeJ Innov]

Thankyou, great help, just what I needed.
Will add to rep.