Nested If

[Suzanne]

Hi, I'm having trouble with making a field in my select query, this is what i
have so far, you can get the gist of what i want to do from it:

Census: IIf([Census Req]<>â€â€ And [Census Rec’d]<>â€â€,â€Sent “ & [Census Req] &
“ Rec’d “ & [Census Rec’d], IIf([Census Req] <>â€â€ And [Census Rec’d]
=â€â€,â€Sent “ & [Census Req], “Rec’d “ & [Census Rec’d]))

If anyone can help i would really appreciate it.

Thanks

 

[orange]

Hi, I'm having trouble with making a field in my select query, this is what i
have so far, you can get the gist of what i want to do from it:

Census: IIf([Census Req]<>â€â€ And [Census Rec’d]<>â€â€,â€Sent “ & [Census Req] &
“ Rec’d “ & [Census Rec’d], IIf([Census Req] <>â€â€ And [Census Rec’d]
=â€â€,â€Sent “ & [Census Req], “Rec’d “ & [Census Rec’d]))

If anyone can help i would really appreciate it.

Thanks

I don't get the gist of it. Seems you have a number of "unprintable" characters.

Try this link for ideas.
http://office.microsoft.com/en-us/access/HA012288531033.aspx