Help with getting correct set of records

[cvegas]

I want to query my table based on the last 30 days of records.

There is a record in the table for every day of the week except Sundays and holidays.



I would like to use the Date picker and after selecting a date then query the table to find the last 30 records (in descending date order) from the selected date.

Any suggestions would be appreciated.

[pbaldy]

Create a query that gets records in the correct order, then either go into the query properties and set the Top Values property, or in SQL view change SELECT... to SELECT TOP 30...

[cvegas]

Worked like a charm
Thanks

[pbaldy]

Happy to help, and greetings from northern NV.