First of all, let me apologize for asking such simple stupid questions. Believe it or not I have done some really cool things with Access and then every now and then I seem to get stumped by something that seems like it should be obvious.
Anyway, here is my problem:
I have a table that contains fields that relate to the tracking of errors for a shipping/receiving environment. One of the specific fields is a date field that stores the value of the date the error was noted (called - noted). I then have a form tied to the table where the administrator enters and views the errors. I am trying to figure out a way to have this form only show errors that were entered (noted) for a set number of days - for example 45 days rolling. I do not want to have to enter a beginning and ending date every time, just always show all records where the - noted - date falls within the past 45 days (whether that is 10 records or 110).
Sounds easy...I'm sure it is, however when I set about doing it I get brain freeze (ticks me off, I feel like a moron).
Thanks for reading
Anyway, here is my problem:
I have a table that contains fields that relate to the tracking of errors for a shipping/receiving environment. One of the specific fields is a date field that stores the value of the date the error was noted (called - noted). I then have a form tied to the table where the administrator enters and views the errors. I am trying to figure out a way to have this form only show errors that were entered (noted) for a set number of days - for example 45 days rolling. I do not want to have to enter a beginning and ending date every time, just always show all records where the - noted - date falls within the past 45 days (whether that is 10 records or 110).
Sounds easy...I'm sure it is, however when I set about doing it I get brain freeze (ticks me off, I feel like a moron).
Thanks for reading
Last edited:
