Report for changes made to table

[fainterm]

What would be the easiest way to create a report where my super users could put in a data range to show which records in a table were changed within the last month?

Basically the users only have access to a single form. On that form, they have unbound controls where they input search criteria. Bound controls display the results below, and a list box is used to update a "location" field. I would like to be able to have a report where I could say "show me all of the records in the table that have been modified in the last 30 days".

Please let me know if I can provide any clarity to the question. Thanks!

[June7]

You have a field that records the last edit date?

[fainterm]

I do have a field on the table that denotes the last modified date. Thanks for the quick response!

[June7]

Try:

SELECT * FROM table WHERE [date field] > Date() - 30;

[fainterm]

Sorry for my delayed response as I got caught up in another project. The line of code you have there. Are you suggesting running a query against the date field? Or are you putting that line of code somewhere in the report properties?

[June7]

That is the SQL statement for a query or the RecordSource of report.

[fainterm]

Got it! Thank you sir. Marking this thread solved!