Microsoft Access Help

[XA04]

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

[Moby-Dick]

does ACCESS SQL support the DATEDIFF command ?

[Moby-Dick]

http://www.database-design-2000.com/dateDiff.htm

[XA04]

Thanks for the reply.

Can't test it on the computer I am using at the moment... but shall try it when I get home.

It looks sort of what I'm looking for, but those dates seem to be fixed... and if I wanted to change it for the last 30 days I'd have to change the query everytime manually...


Sorry if that's not very clear, I'll try to explain again..

I have managed to make a query so that it shows ALL the dates before the date I enter into the dialog box. But what I want to do is so that BEFORE the last 30 days(not during the last 30 days.. anything before) all the dates are shown.

It's basicly for an overdue payment system I'm making (school work).

So what would I need to modify from what I've already got?:
<[Enter Date (In format: DD/MM/YYYY)]

'<' is for less than.. and the square brackets is for the message in the dialog box, which shows an empty box to enter data, so basicly if you entered todays date into the box the command would be:
<16/01/2006
and that works fine - and shows all the dates before today, but I want it before the last 30 days.

If anyone can help that would be great.

Thanks!

[Moby-Dick]

so you want to show files for a range of (getdate()-30) - again I dunno if access supports getdate either.

[herulach]

Access has pretty good date commands, I think something along the lines of Now()-<Function thats used to cast to a number of days>(30) shoudl work,. theres an example in the help IIRC

[XA04]

Hmm, I think you guys are on the right track to what I mean now. But I'm still not sure how to implement what your saying.

I'm at home now, here is a screenshot if it helps..



Thanks

[herulach]

Its actually DateAdd('d',-30,Now()), that gets you the date 30 days ago, and im sure you can manage the rest.

[fuddam]

even easier:

<Now()-30



works in days regardless, unless you tell it otherwise

[XA04]

Its actually DateAdd('d',-30,Now()), that gets you the date 30 days ago, and im sure you can manage the rest.

Can't seem to get that to work?

even easier:

<Now()-30



works in days regardless, unless you tell it otherwise

Yeah that works thanks.