Date function

  • Thread starter Thread starter Techknownothing
  • Start date Start date
T

Techknownothing

I would like a query to only show records that were input within the
last 90 days.
Presently, users input the date they created the record into a field
whenever a record is added.
Can someone point my in the right direction?

Jeff
 
Hi Jeff,

Create a new query in design view with all the fields you want in the
query results - including your date field.

In the date field's criteria enter "Between Now() and Now()-90"

Also, if you want the default created date to be today's date when a
user inputs a record. Open your table in design view, click on the date
field and enter "Now()" in the Default Value area.

Hope this helps,

David
 
Hi Jeff,

Create a new query in design view with all the fields you want in the
query results - including your date field.

In the date field's criteria enter "Between Now() and Now()-90"

Also, if you want the default created date to be today's date when a
user inputs a record. Open your table in design view, click on the date
field and enter "Now()" in the Default Value area.

Hope this helps,

David
 
Like a charm!
Thank you!

Jeff
Hi Jeff,

Create a new query in design view with all the fields you want in the
query results - including your date field.

In the date field's criteria enter "Between Now() and Now()-90"

Also, if you want the default created date to be today's date when a
user inputs a record. Open your table in design view, click on the date
field and enter "Now()" in the Default Value area.

Hope this helps,

David
Click to expand...
 
Back
Top