IF statement query

[gojohnnygogogogo]

hello, can anybody see why this just brings back a blank screen ? :

=IIf([CountofSheetID]>0,[CountofSheetID] & " records added.","no records to add&quot

 

[AyJayEL]

Sorry I can't resist this. I don't know the answer to your question but 'You're my wife now Dave'. Anyone who is a League of Gentlemen fan really deserves to get their question answered! Learn something new every day *:->*

 

[jebry]

Hi!

In what situation is this IIf being used? What do you mean that it brings back a blank screen?

Jeff Bridgham
bridgham@purdue.edu

 

[SteveNapper]

Sorry to interupt, do you know the standard SQL equivalent to IIf?

Thanks and apologies again

 

[gojohnnygogogogo]

hi Jeff,
I am using this IIF statement in a textbox on a form.
I run the query to insert records, then the form opened after that is based on a query to show the records with date = now().
If records are added, then the form works , displaying the number of records added, but if no records are added the form is just blank.

and by the way this is gojohnny go go go go, not flabber wassa tidgevadge !

 

[Shinken]

Have you tried something like:

strMsg = IIf(etc...)
MsgBox(strMsg)

Shin

 

[blom0344]

Does this work:

=IIf([CountofSheetID]>0,Str([CountofSheetID]) & " records added.","no records to add&quot
T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[Supercow]

SteveNapper: you can replace IIF with case in a SQL query. Hope it helps

SC

 

[blom0344]

Jet SQL does not work with Case , you will have to write some VBA function to work with Case, which will be quite a good idea after all .................. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com