Problem with query criteria

[bibstar03]

I am doing a database which contains data dated in the past. I need criteria which will open a query and show data for the last month.

E.g. on the 28feb i want to open a query which shows the data from the 1st feb - today, if possible i do not want the user to have to type in any dates.

Thanks for any help

 

[bat17]

use
>=DateSerial(Year(Date()),Month(Date()),1)
as the criteria for the date field in your query

HTH

Peter

 

[bibstar03]

Thanks but that doesn't work, i copied the formula into the criteria but had no luck!

 

[Tanis]

You have to use your own date field name.

>=DateSerial(Year([YourDateFieldName]),Month([YourDateFieldName]),1)

 

[Tanis]

Sorry, the criteria should be

>=DateSerial(Year(Date()),Month([YourDateFieldName]),1)

David

 

[bat17]

Nope, my formula gives the first of the current month, so entering it now should give you all of the records from Jan 1 2004
In what way did it not work? what results did you get?

did you actualy want data for the current month or for last month?

Peter

 

[bibstar03]

No that criteria doesn't work, maybe i'm entering it in wrong, i'm what you could call a newbe. The criteria im entering just brings up all the dates????

thanks again

Bibstar

 

[bat17]

If you could post the SQL from the query we can see if we can spot something.

Peter

 

[bibstar03]

>=DateSerial(Year([Date]),Month([Date]),1)

That field is called Date

it brings up dates from over a month ago, dates duing the month and dates in the future?????

Thanks

 

[bat17]

The problem is that you are using [date] which is your field rather than Date() which is a built in function. You are telling it to give you everything greater than the first day of the month in which the record was recorded.
try just copying my formula into your criteria cell and see what happens.

>=DateSerial(Year(Date()),Month(Date()),1)

Peter