I've got a table with some dates in it, and I've written a query so that a dialog box comes up when run (it asks for TODAY's date).
Now I've managed to show all the listings with the previous date of the day entered today (Using: <[Enter Date (In format: DD/MM/YYYY)]
Which works fine for showing all previous dates... but what do I need to do for only showing dates before the last 30 days?
Need it for school coursework, teacher doesn't seem to know how to do this!
Thanks