The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Microsoft Access: IIf in Queries/Criteria
Seguer
of the VoidSydney, AustraliaRegistered User regular
of the VoidSydney, AustraliaRegistered User regular
I hate Access too, but I have to use it.
I have the current IIf in a query for criteria:
Now, through research, I am already aware that IIf can't handle wildcards; it takes them literally. However, I'm not even sure this is getting the value at all, and have no idea where the problem lies.
Has anyone else come across a similar problem, or have used IIf in criteria before?
I have the current IIf in a query for criteria:
IIf([Forms]![frmStartup]![chkSalesReportDontShowADJ].[Value],"Not Like 'ADJ'","*")
Now, through research, I am already aware that IIf can't handle wildcards; it takes them literally. However, I'm not even sure this is getting the value at all, and have no idea where the problem lies.
Has anyone else come across a similar problem, or have used IIf in criteria before?
Seguer on
0