Query - Training Database

[AndyTH]

Hi,

I am developing a database and would like to apply filter to some reports that will restrict the records listed to within the last 30 days



An example of a form being used is:

Field: Date

Table: TblCourses

Sort: Descending





Any help or assistance you could give would be greatly appreciated. If I've omitted any important details please don't hesitate to ask.



Many thanks,



A

[Allan Murphy]

Andy

Do not use Date as a field name as it is a reserved word. You could use course_date.

I assume that Date is the date of the course. If so in your query for your reports in the criteria for the date enter >=date()-30. This will display records for courses during the last 30 days.

[Island1]

If you parameterize the number of days (instead of hard coding "30 days") , so that the information consumer can supply that number in ad hoc fashion at runtime, you can do significantly "more with less." It might be a good idea to ask if any users would find this useful ...

And, worst case, you get points for asking ...

Good Luck,

Bill