MS Access - how to get date range of 30 days [closed]

Question

Navigation

#1 by (0 votes)

0

I need to collect registered orders from a table named OrdersOn the last 30 days.

sql ms-access

asked by anonymous 24.07.2014 / 15:30

1 answer

score 0 · Accepted Answer

In your query, use the expression SomData() ( or DateAdd() in Access) as the criteria in the date following form:

>= SomData("d"; -30; Data() )

It makes a WHERE of the field returning all the dates of the last 30 days. Field type must be Data