Hi.

i.e
I have a query with the following sort of information:-

Month Amount
08/2007 £100
09/2007 £200
10/2007 £55
11/2007 £60

As today being the 1st October, I would like the query to return the values for Oct and Nov.
The same values would be returned on the 31st Oct, but then the following day, only the Nov value would be returned...so, basically, it only returns the values of the current month and following months..

I am assuming I put something in the criteria of the query under the month? I have tried a number of things, with none working!!!

Thanks for reading....

Frank.

Typical.......the minute you post, seem to find the answer from a previous post...

I added this to the criteria

>Month(Date())

Apologies all.

Frank.