Between Formula

  • Thread starter Thread starter Maria
  • Start date Start date
M

Maria

I am using Access 2000

I have a query with the following formula in it.

NextCalDate: IIf([Gage Infor].[Freq]=999,"Before Use",
([Gage Infor].[Freq]+[Gage Infor].[LastCalDate]))

This formula give me the next date a calibration is due to
be completed on a piece of equipment.

I want to only pull up records that have a "NextCalDate"
for next month. I entered the following formula in the
criteria section, but it did not work. It gives me a
blank answer.

Between [Enter Start Date] And [Enter End Date]

I can use >date and <date and this works. But not the
between formula. Can anyone tell me what is wrong?

Maria
 
NextCalDate is apparently a text field and not a date, as evident by your
insertion of "Before Use". It must contain a date and only dates.
 
Paul - thank you for answering my question.

Even though this field calculated dates and gave me dates,
I changed the formula to eliminate the text "before".
This is now the new formula

([Gage Infor].[Freq]+[Gage Infor].[LastCalDate])
Where [Freq} is a number of days and [LastCalDate] is the
last date a calibration was done. To give me the date the
next calibration is due.

But I still can not get the between formula to work. The
questions come up but the answer is blank. Again using >
and < works and gives me the dates that I need. But I
need to make this Db program user friendly for people who
know nothing about using a Db.

Do you have any suggestions???????????

-----Original Message-----
NextCalDate is apparently a text field and not a date, as evident by your
insertion of "Before Use". It must contain a date and only dates.

--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com


I am using Access 2000

I have a query with the following formula in it.

NextCalDate: IIf([Gage Infor].[Freq]=999,"Before Use",
([Gage Infor].[Freq]+[Gage Infor].[LastCalDate]))

This formula give me the next date a calibration is due to
be completed on a piece of equipment.

I want to only pull up records that have a "NextCalDate"
for next month. I entered the following formula in the
criteria section, but it did not work. It gives me a
blank answer.

Between [Enter Start Date] And [Enter End Date]

I can use >date and <date and this works. But not the
between formula. Can anyone tell me what is wrong?

Maria
Click to expand...


.
Click to expand...
 
Back
Top