Calculated Date Field

[Guest]

I am using Access 2003
I am trying to create a Preventative Mtce (PMs) Db. I have 3 tables, (1)
Basic Mach Infor, (2) PM Operations (oper#) Required by Machine #, (3)
PrevMtce that has been completed. Machine # is the one field that connects
all 3 tables and Oper# connects the Operations Required with the PrevMtce
Completed Table. I want a Report that will tell me which machines require
PM's. Based on the last PM Date + the frequency that it needs to be done.
So in my query I added a calculated field that adds the date the last PM was
completed and the frequency that it should be done to give me the date of
when the next PM is due. This works fine. I get the dates that I am looking
for. But, I want to make this easy for the operator so I wanted to add in
the criteria a "Between/And" so that the operator could add the dates he is
looking for - Ex: PM's due between 9/1/06 and 9/15/06. He needs to be
able to look into the future so that he can see what materials he is going to
need. I can not make the Between/And work. Is there a way to do this in a
calculated field? Or is there another way to do this?

Please help me if you can - aurora

 

[Marshall Barton]

I am using Access 2003
I am trying to create a Preventative Mtce (PMs) Db. I have 3 tables, (1)
Basic Mach Infor, (2) PM Operations (oper#) Required by Machine #, (3)
PrevMtce that has been completed. Machine # is the one field that connects
all 3 tables and Oper# connects the Operations Required with the PrevMtce
Completed Table. I want a Report that will tell me which machines require
PM's. Based on the last PM Date + the frequency that it needs to be done.
So in my query I added a calculated field that adds the date the last PM was
completed and the frequency that it should be done to give me the date of
when the next PM is due. This works fine. I get the dates that I am looking
for. But, I want to make this easy for the operator so I wanted to add in
the criteria a "Between/And" so that the operator could add the dates he is
looking for - Ex: PM's due between 9/1/06 and 9/15/06. He needs to be
able to look into the future so that he can see what materials he is going to
need. I can not make the Between/And work. Is there a way to do this in a
calculated field? Or is there another way to do this?

What have you tried? Setting the criteria to use Between is
no different from any other kind of criteria. If you want
to prompt for the fate rangem then you could set the
calculated field's criteria to something like:

Between [Enter Start Date] AND [Enter End Date]