Aug 7 2006, 11:41 AM
I am a newbie to databases in general. I am trying to create a query that will select all records that that have been received (date) and reviewed (date) in less than 5 days. When the following query is run, a pop-up box comes up asking me for the DAY. Can anyone help? Thanks.
(SELECT [record] FROM [table] WHERE DATEDIFF (Day, DateReceived, DateReviewed)< 5
Aug 7 2006, 11:52 AM
welcome to UA forums.
The interval argument part would be "d" and not Day!
But...don't use this in the criteria...instead set up a new expression in query design view e.g.:
Then use this expressions criteria area to filter out what you want e.g.: