Date Selection for report

[JimUK]

I have a simple Equipment table that I want to make a report weekly that shows me what equipment is due calibration in the next 2 weeks. This is not the problem, I'm doing this with query Date() and looking 14 days in advance.
The problem arises when a piece of equipment cannot be taken for calibration ( maybe because it is needed in place)or is overdue. How would I show this on the report along with the normal Date() + 14 days?

Jim

 

[dhookom]

I think we need more information about your data and requirements. Your question assumes we have an understanding about your system that we clearly don't. Maybe someone else can make a WAG but it would be easier if you would provide better information.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[JimUK]

Sorry Duane, let me try to make it more clear. In my Equipment table I have fields Date_Calibrated and Date_Due along with others fields related to that Equipment. In the Query for this particular report I am using Between Date() And Date() + "14" and this is done every Friday. This works fine and gives me a list of all the equipment that is due calibration for the next 2 weeks. The problem I am running into is if this equipment is not signed out for Calibration for some reason, i.e. operator may have to keep equipment in system for a certain job. This equipment then becomes "overdue" for calibration. The next Friday comes along and if the Date_Due was sometime within the last 7 days my query will now not pickup this equipment as being due calibration. There has to be a simple way to do this, it's just escaping me at the moment.
Thanks for your quick response.

Jim

 

[GoDawgs]

How bout using "between Date()-7 and Date()+14" instead? That way you pick up the last week's stuff too...