|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 12th, 2010, 11:25 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Nested If
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 
|
|
#2
January 13th, 2010, 12:12 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Nested If
Might it be that the fields are Null rather than containing zero-length
strings? To cover both possibilities: 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])) Ken Sheridan Stafford, England Suzanne wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201001/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
