Parameter Query with multiple options for criteria

  • Thread starter Thread starter Fester
  • Start date Start date
F

Fester

I have a query that uses a textbox for the Parameter value. Basically
it's a hardware report by region. I can get it to query on a single
value, but how do I get it to show all records (essentially, a blank
parameter field)?
 
Works like a charm, thank you.


Hi,

try like [Forms]![MyForm]![MyField] & "*" as a criterium.
--
Kind regards
Noëlla



Fester said:
I have a query that uses a textbox for the Parameter value. Basically
it's a hardware report by region.  I can get it to query on a single
value, but how do I get it to show all records (essentially, a blank
parameter field)?- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...
 
How do you do it if the query is between [start date] and [end date] - it
doesn't work to do like between [start date] and [end date] & "*"

Fester said:
Works like a charm, thank you.


Hi,

try like [Forms]![MyForm]![MyField] & "*" as a criterium.
--
Kind regards
Noëlla



Fester said:
I have a query that uses a textbox for the Parameter value. Basically
it's a hardware report by region. I can get it to query on a single
value, but how do I get it to show all records (essentially, a blank
parameter field)?- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...
Click to expand...
 
Tamara said:
How do you do it if the query is between [start date] and [end date] - it
doesn't work to do like between [start date] and [end date] & "*"

Fester said:
Works like a charm, thank you.


Hi,

try like [Forms]![MyForm]![MyField] & "*" as a criterium.
--
Kind regards
Noëlla



:
I have a query that uses a textbox for the Parameter value. Basically
it's a hardware report by region. I can get it to query on a single
value, but how do I get it to show all records (essentially, a blank
parameter field)?- Hide quoted text -

- Show quoted text -
Click to expand...
Click to expand...
Click to expand...
 
Back
Top