wildcard number used in iif statement

[pat c]

My query looks at a textbox which is a customer number from a form as part of
an IIF statement as criteria in a query.
IIF(isnull([findcust]), wildcard number ,[findcust])

I tried "*" but it only works on text, not on numeric field, what shoud I
type to return all record?

 

[John Spencer]

Field: Customer Number
Criteria: [Find Cust] OR [Find Cust] is Null

Access will restructure the query when you save it.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[pat c]

Sorry John,

I don't get it, what shoud I type to save in order for access to restructure
the query?

Thanks for your help!!

Field: Customer Number
Criteria: [Find Cust] OR [Find Cust] is Null

Access will restructure the query when you save it.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

My query looks at a textbox which is a customer number from a form as part
of
an IIF statement as criteria in a query.
IIF(isnull([findcust]), wildcard number ,[findcust])

I tried "*" but it only works on text, not on numeric field, what shoud I
type to return all record?

 

[John Spencer]

I assumed that you were using Design view.

Type the criteria as indicated.

Close and save the query
Reopen it and you will see that it has been restructured.

BEFORE you do that make a backup copy of the query in case this is NOT what
you want.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Sorry John,

I don't get it, what shoud I type to save in order for access to
restructure
the query?

Thanks for your help!!

Field: Customer Number
Criteria: [Find Cust] OR [Find Cust] is Null

Access will restructure the query when you save it.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

My query looks at a textbox which is a customer number from a form as
part
of
an IIF statement as criteria in a query.
IIF(isnull([findcust]), wildcard number ,[findcust])

I tried "*" but it only works on text, not on numeric field, what shoud
I
type to return all record?

 

[pat c]

it works!!
Thanks very much for your help, John.

I assumed that you were using Design view.

Type the criteria as indicated.

Close and save the query
Reopen it and you will see that it has been restructured.

BEFORE you do that make a backup copy of the query in case this is NOT what
you want.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Sorry John,

I don't get it, what shoud I type to save in order for access to
restructure
the query?

Thanks for your help!!

Field: Customer Number
Criteria: [Find Cust] OR [Find Cust] is Null

Access will restructure the query when you save it.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

My query looks at a textbox which is a customer number from a form as
part
of
an IIF statement as criteria in a query.
IIF(isnull([findcust]), wildcard number ,[findcust])

I tried "*" but it only works on text, not on numeric field, what shoud
I
type to return all record?