number parameterized query, "blank = all"?

[Guest]

I found the MSKB article on how to create a paramter INStr() with criteria =
Criteria: > 0 Or Is Null for an all search on customer name. What (if
there is) is the equivalent for an all search by a (customer) number? I
tried the same and it didn't work. Cockpit error or is there a different
syntax needed?

P.S. I already have syntax that allows for a list of numbers

tia.

HB

 

[Duane Hookom]

Provide:
- the MSKB number
- Your query SQL
- syntax of your expressions used
- field names and data types
- list of what you tried and what errors you got

 

[Guest]

http://support.microsoft.com/kb/q100131/

Expr1: InStr("," & [Type Member Numbers separated by commas,Blank=All] &
",","," & [MemberNumber] & ",")

criteria: >0 .....but I see I didn't have the "or is null"....I'll try
that The error is that the Members window comes up with a new record.

 

[Guest]

I added the or is null, but the query returns no rows if it is left blank.
What do I need to do to have an "all" query, based on a number field, similar
to the "all" query for a text field?

http://support.microsoft.com/kb/q100131/

Expr1: InStr("," & [Type Member Numbers separated by commas,Blank=All] &
",","," & [MemberNumber] & ",")

criteria: >0 .....but I see I didn't have the "or is null"....I'll try
that The error is that the Members window comes up with a new record.

Provide:
- the MSKB number
- Your query SQL
- syntax of your expressions used
- field names and data types
- list of what you tried and what errors you got

 

[Duane Hookom]

Try:
Expr1: InStr("," & Nz([Type Member Numbers separated by commas,Blank=All],
[MemberNumber]) & "," , "," & [MemberNumber] & ",")

--
Duane Hookom
MS Access MVP
--

I added the or is null, but the query returns no rows if it is left blank.
What do I need to do to have an "all" query, based on a number field,
similar
to the "all" query for a text field?

http://support.microsoft.com/kb/q100131/

Expr1: InStr("," & [Type Member Numbers separated by commas,Blank=All] &
",","," & [MemberNumber] & ",")

criteria: >0 .....but I see I didn't have the "or is null"....I'll try
that The error is that the Members window comes up with a new record.

Provide:
- the MSKB number
- Your query SQL
- syntax of your expressions used
- field names and data types
- list of what you tried and what errors you got


--
Duane Hookom
MS Access MVP


I found the MSKB article on how to create a paramter INStr() with
criteria
=
Criteria: > 0 Or Is Null for an all search on customer name.
What (if
there is) is the equivalent for an all search by a (customer) number?
I
tried the same and it didn't work. Cockpit error or is there a
different
syntax needed?

P.S. I already have syntax that allows for a list of numbers

tia.

HB

 

[Guest]

Thanks again. That did it!

Try:
Expr1: InStr("," & Nz([Type Member Numbers separated by commas,Blank=All],
[MemberNumber]) & "," , "," & [MemberNumber] & ",")

--
Duane Hookom
MS Access MVP
--

I added the or is null, but the query returns no rows if it is left blank.
What do I need to do to have an "all" query, based on a number field,
similar
to the "all" query for a text field?

http://support.microsoft.com/kb/q100131/

Expr1: InStr("," & [Type Member Numbers separated by commas,Blank=All] &
",","," & [MemberNumber] & ",")

criteria: >0 .....but I see I didn't have the "or is null"....I'll try
that The error is that the Members window comes up with a new record.


:

Provide:
- the MSKB number
- Your query SQL
- syntax of your expressions used
- field names and data types
- list of what you tried and what errors you got


--
Duane Hookom
MS Access MVP


I found the MSKB article on how to create a paramter INStr() with
criteria
=
Criteria: > 0 Or Is Null for an all search on customer name.
What (if
there is) is the equivalent for an all search by a (customer) number?
I
tried the same and it didn't work. Cockpit error or is there a
different
syntax needed?

P.S. I already have syntax that allows for a list of numbers

tia.

HB