get last 5 days of data

[skifreak]

I want to do the following in Access. This did not work



SELECT *FROM [mytable]WHERE (DATEDIFF(day, [date_field], GETDATE()) < 5)

[pbaldy]

The equivalent of GETDATE() in Access is Now().

[skifreak]

This did not work. It is asking me for the 'Day' parameter.

SELECT * FROM [billing]WHERE (DATEDIFF(day, [Date Request Received], now()) < 5)

[pbaldy]

Sorry, missed that. In Access replace day with "d". You can find the syntax in help.