Hi Robin
This should do the trick:
WHERE [TimestampField] >= Date()-3
Best wishes,
Graham
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, 28 March 2017 11:41
To: MS Access Professionals-yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Subject: [MS_AccessPros] Code for recent days
"Old Timer's Disease" has taken over! I have a database where each
record is dated after an update. I have a query to show me the
records that have been changed in the past three days. How do I write
the code for the criteria to achieve my aim?
Many thanks,
Robin Chapple
__._,_.___
Posted by: "Graham Mandeno" <graham@mandeno.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar