Multiple Serial Number Query

  • Thread starter Thread starter Denise
  • Start date Start date
D

Denise

I have a query that selects a serial number [type serial
number] in criteria. I need to be able to choose multiple
serial numbers, a different amount each time. How do I do
that?

Thank you for your help.
 
If im understanding your question correclty u want 2 b
able 2 filter by multiple values...if this is correct try
using the In("filter1","filter2","filter3"). Place this
statement in the criteria sectionof the field u r applying
a filter 2...
 
I am sorry but I do not understand what you mean. Do I
put In("filter1","filter2","filter3") in my query in the
serial number field?

Thanks

-----Original Message-----
If im understanding your question correclty u want 2 b
able 2 filter by multiple values...if this is correct try
using the In("filter1","filter2","filter3"). Place this
statement in the criteria sectionof the field u r applying
a filter 2...
-----Original Message-----
I have a query that selects a serial number [type serial
number] in criteria. I need to be able to choose multiple
serial numbers, a different amount each time. How do I do
that?

Thank you for your help.

.
Click to expand...
.
Click to expand...
 
Sorry 4 not making myself clear...
In("filter1","filter2","filter3")
filer1 would be the 1st value u r filtering 4, filer2
would be the 2nd value u r filtering 4, filer3 would be
the 3rd value u r filtering 4 and so on and so forth...so
if the values u filtering 4 r 1, 2 and 3 the statement
would look like
IN("1","2","3")


-----Original Message-----
I am sorry but I do not understand what you mean. Do I
put In("filter1","filter2","filter3") in my query in the
serial number field?

Thanks

-----Original Message-----
If im understanding your question correclty u want 2 b
able 2 filter by multiple values...if this is correct try
using the In("filter1","filter2","filter3"). Place this
statement in the criteria sectionof the field u r applying
a filter 2...
-----Original Message-----
I have a query that selects a serial number [type serial
number] in criteria. I need to be able to choose multiple
serial numbers, a different amount each time. How do I do
that?

Thank you for your help.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Thank you.
-----Original Message-----
Sorry 4 not making myself clear...
In("filter1","filter2","filter3")
filer1 would be the 1st value u r filtering 4, filer2
would be the 2nd value u r filtering 4, filer3 would be
the 3rd value u r filtering 4 and so on and so forth...so
if the values u filtering 4 r 1, 2 and 3 the statement
would look like
IN("1","2","3")


-----Original Message-----
I am sorry but I do not understand what you mean. Do I
put In("filter1","filter2","filter3") in my query in the
serial number field?

Thanks

-----Original Message-----
If im understanding your question correclty u want 2 b
able 2 filter by multiple values...if this is correct try
using the In("filter1","filter2","filter3"). Place this
statement in the criteria sectionof the field u r applying
a filter 2...

-----Original Message-----
I have a query that selects a serial number [type serial
number] in criteria. I need to be able to choose
multiple
serial numbers, a different amount each time. How do I
do
that?

Thank you for your help.

.

.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top