IF else criteria in query

[Sean G.]

Hello,

I'm trying to do an if else for criteria in a query. If
the condition is met I want to grab all the data in the
query, otherwise if it isn't met I want to grab some
criterion.... I have tried it with "*", but that doesn't
seem to work, here is my iif:
IIf([forms]![frmParam_Date_ofc]![Office1] Is
Null,"*","WMS")
Any help would be very much apperciated...

-Sean

 

[fredg]

Hello,

I'm trying to do an if else for criteria in a query. If
the condition is met I want to grab all the data in the
query, otherwise if it isn't met I want to grab some
criterion.... I have tried it with "*", but that doesn't
seem to work, here is my iif:
IIf([forms]![frmParam_Date_ofc]![Office1] Is
Null,"*","WMS")
Any help would be very much apperciated...

-Sean

Like IIf(IsNull([forms]![frmParam_Date_ofc]![Office1]),"*","WMS")

The form must still be open when this query is run.

 

[Guest]

Fred,

That worked great, except if I want to do an "or" in the
else... For example:
Like IIf(IsNull([forms]![frmParam_Date_ofc]!
[Office1]),"*","WMS" or "BUF")

That doesn't work, how would I put an or into it? thank
you!

-----Original Message-----

Hello,

I'm trying to do an if else for criteria in a query. If
the condition is met I want to grab all the data in the
query, otherwise if it isn't met I want to grab some
criterion.... I have tried it with "*", but that doesn't
seem to work, here is my iif:
IIf([forms]![frmParam_Date_ofc]![Office1] Is
Null,"*","WMS")
Any help would be very much apperciated...

-Sean

Like IIf(IsNull([forms]![frmParam_Date_ofc]! [Office1]),"*","WMS")

The form must still be open when this query is run.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

 

[Douglas J. Steele]

Like IIf(IsNull([forms]![frmParam_Date_ofc]![Office1]),"*","WMS") OR Like
IIf(IsNull([forms]![frmParam_Date_ofc]![Office1]),"*","BUF")

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Fred,

That worked great, except if I want to do an "or" in the
else... For example:
Like IIf(IsNull([forms]![frmParam_Date_ofc]!
[Office1]),"*","WMS" or "BUF")

That doesn't work, how would I put an or into it? thank
you!

-----Original Message-----

Hello,

I'm trying to do an if else for criteria in a query. If
the condition is met I want to grab all the data in the
query, otherwise if it isn't met I want to grab some
criterion.... I have tried it with "*", but that doesn't
seem to work, here is my iif:
IIf([forms]![frmParam_Date_ofc]![Office1] Is
Null,"*","WMS")
Any help would be very much apperciated...

-Sean

Like IIf(IsNull([forms]![frmParam_Date_ofc]! [Office1]),"*","WMS")

The form must still be open when this query is run.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

 

[Sean G.]

Thank you very much that worked great!

-----Original Message-----
Like IIf(IsNull([forms]![frmParam_Date_ofc]! [Office1]),"*","WMS") OR Like
IIf(IsNull([forms]![frmParam_Date_ofc]! [Office1]),"*","BUF")

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Fred,

That worked great, except if I want to do an "or" in the
else... For example:
Like IIf(IsNull([forms]![frmParam_Date_ofc]!
[Office1]),"*","WMS" or "BUF")

That doesn't work, how would I put an or into it? thank
you!

-----Original Message-----
On Fri, 18 Jun 2004 07:25:32 -0700, Sean G. wrote:

Hello,

I'm trying to do an if else for criteria in a query. If
the condition is met I want to grab all the data in the
query, otherwise if it isn't met I want to grab some
criterion.... I have tried it with "*", but that doesn't
seem to work, here is my iif:
IIf([forms]![frmParam_Date_ofc]![Office1] Is
Null,"*","WMS")
Any help would be very much apperciated...

-Sean

Like IIf(IsNull([forms]![frmParam_Date_ofc]! [Office1]),"*","WMS")

The form must still be open when this query is run.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

.