New Records Created by Date

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

I would like to create a query, which shows any new record(s) created within
the last week (seven days). I've had a look on the internet and cannot seem
to find anything which relates to what I require.

The table I will be linking the query from has a "DateCreated" field which
uses the Date Format within it (DD/MM/YYYY).

Any suggestions would be gratefully received.

Thanks in advance.
 
Daniel,
Use the DateAdd function as a criteria against your DateCreated field...
DateAdd("ww",-1,Date())
Click to expand...

Two fields that are often used in tables are
DOC (Date of Creation)
and
DOLE (Date of Last Edit)

On my website (below) I have a 97 and 2003 sample file called
RecordStatistics, that you might find helpful.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top