S
Suzanne
I created a new field "2008CensusRemarks" in my query which combines two
seperate fields "Special Remarks" & "2008 Annual Grid.Remarks with a ;.
Here's what i've come up with:
2008CensusRemarks: IIf([Special Remarks]<>"" And [2008 Annual
Grid.Remarks]<>"",[Special Remarks] & "; " & [2008 Annual Grid.Remarks],
IIf([Special Remarks]<>â€â€ And [2008 Annual Grid.Remarks]=â€â€, [Special
Remarks], [2008 Annual Grid.Remarks]))
This does not work...
What i'm trying to say is this:
1. If [Special Remarks] and [2008 Annual Grid.Remarks] are not blank display
with a ; between them, or
2. If [Special Remarks] is not blank and [2008 Annual Grid.Remarks] is blank
display [Special Remarks], or
3. If [Special Remarks] is blank and [2008 Annual Grid.Remarks] is not blank
display [2008 Annual Grid.Remarks]
Any help would be greatly appreciated.
seperate fields "Special Remarks" & "2008 Annual Grid.Remarks with a ;.
Here's what i've come up with:
2008CensusRemarks: IIf([Special Remarks]<>"" And [2008 Annual
Grid.Remarks]<>"",[Special Remarks] & "; " & [2008 Annual Grid.Remarks],
IIf([Special Remarks]<>â€â€ And [2008 Annual Grid.Remarks]=â€â€, [Special
Remarks], [2008 Annual Grid.Remarks]))
This does not work...
What i'm trying to say is this:
1. If [Special Remarks] and [2008 Annual Grid.Remarks] are not blank display
with a ; between them, or
2. If [Special Remarks] is not blank and [2008 Annual Grid.Remarks] is blank
display [Special Remarks], or
3. If [Special Remarks] is blank and [2008 Annual Grid.Remarks] is not blank
display [2008 Annual Grid.Remarks]
Any help would be greatly appreciated.