W
wisemax
A table having two records
BuildingName PurchaseDate PurchasePrice
East 1-1-2000 10,000,000
West 1-1-2001 12,000,000
A query having two fields
EastMonths:IIf([BuildingName]="East",DateDiff("m",[Forms]![Balance
Sheet Dialog]![EndingDate],[PurchaseDate])*-1)
WestMonths:IIf([BuildingName]="West",DateDiff("m",[Forms]![Balance
Sheet Dialog]![EndingDate],[PurchaseDate])*-1)
I want to calculate how many months since the purchase of the
buildings.
My question is why there are blank cells?
EastMonths WestMonths
18 blank
blank 30
Why the result does not look like
EastMonths WestMonths
18 30
BuildingName PurchaseDate PurchasePrice
East 1-1-2000 10,000,000
West 1-1-2001 12,000,000
A query having two fields
EastMonths:IIf([BuildingName]="East",DateDiff("m",[Forms]![Balance
Sheet Dialog]![EndingDate],[PurchaseDate])*-1)
WestMonths:IIf([BuildingName]="West",DateDiff("m",[Forms]![Balance
Sheet Dialog]![EndingDate],[PurchaseDate])*-1)
I want to calculate how many months since the purchase of the
buildings.
My question is why there are blank cells?
EastMonths WestMonths
18 blank
blank 30
Why the result does not look like
EastMonths WestMonths
18 30