crystalfun
Programmer
I have a field called "Acq Date" and a second field called "Depr Start date." The Depr start date should be the first day of the first month after Acq Date.
I would like to write a query that shows me all items where the month of Depr Start Date does not equal one month after acq date. Example would be to see an item if Acq Date is 3/17/04 and Depr start date is 5/1/04. I want to see it. If Depr start date is 4/1/04 its OK and I don't want to see it.
The first three columns of my query are AssetID, Acq Date, Depr Start Date.
I inserted 2 more columns - The first showed the month of the Acq date: AcqDate: Month([Fixed Assets]![Acq Date])
The second column was the month of the Depr Start Date: MonthDepr: Month([Fixed Assets]![Dep Start Date])
In the next column I calculated the difference between the two with the following: Difference: ([MonthDepr])-([AcqDate])
I only want to see items <> 1 or <> -11 but when I put that in the criteria the query asks me to Enter a Parameter value. I don't want to enter a value so what am I doing wrong. I only want to see records where the difference between the two months is <> 1 or <> -11. I'm sure it's simple but it's driving me crazy.
I would like to write a query that shows me all items where the month of Depr Start Date does not equal one month after acq date. Example would be to see an item if Acq Date is 3/17/04 and Depr start date is 5/1/04. I want to see it. If Depr start date is 4/1/04 its OK and I don't want to see it.
The first three columns of my query are AssetID, Acq Date, Depr Start Date.
I inserted 2 more columns - The first showed the month of the Acq date: AcqDate: Month([Fixed Assets]![Acq Date])
The second column was the month of the Depr Start Date: MonthDepr: Month([Fixed Assets]![Dep Start Date])
In the next column I calculated the difference between the two with the following: Difference: ([MonthDepr])-([AcqDate])
I only want to see items <> 1 or <> -11 but when I put that in the criteria the query asks me to Enter a Parameter value. I don't want to enter a value so what am I doing wrong. I only want to see records where the difference between the two months is <> 1 or <> -11. I'm sure it's simple but it's driving me crazy.