Parameter Query with multiple options for criteria

[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)?

 

[NG]

Hi,

try like [Forms]![MyForm]![MyField] & "*" as a criterium.

 

[Fester]

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 -

 

[Tamara]

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] & "*"

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 -

 

[MAITE 339 hotnail.com]

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] & "*"

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 -