Filter most recent week in data entry form

[Tlewman]

I have a form, based on a table, that I enter data into each morning. I have imported the last years worth of data into my table so there are quite a few records in my table. My questions is: How do I get my form to only show the most recent weeks worth of data. I had created a query and sorted my dates desc- giving me my most recent weeks first then limited it to my top 7 records (for the last 7 days). I then used this query as a filter on a macro that is attached to the button that opens the form. When I open it, the form still shows all records in the table (the most recent weeks are at the top, but it doesn't restrict to the top 7). What am I doing wrong?

 

[Andrew Fergus]

Hi,

have you considered basing the form on a query rather than the table? If you always want to show just the last week's records, in the query you can use an automatic filter such as <Now() - 8 {or something similar} in the criteria under the date field.

Alternatively the query could have a date criteria such as <=[enter first date] {or something simliar to take account of a null entry} and you can choose how many records you want to display every time the form opens - you could then change your button macro to close and reopen the form if you want to change the filter.

Lastly, there is an 'Apply Filter' option under the macro functions but I can't help you with that given I don't have Access on this PC and can't remember how to use it off the top of my head.

HTH, Andrew.