Parameter Query - not working when on parameter not entered

[Guest]

I have a query with two tables: Table1, Table2
The fields in the query are :

Field Region Super Date
Table Table1 Table2 Table2
Criteria [Enter Region] Like [Enter Super] & * Between [Beginning date] and
[End Date]

The query works fine if I enter all three parameters. If I enter only the
Region and Date parameters it will only return records that have a value in
the Super field, if will not return the records if the super field is blank.

I would appreciate instruction on how to get this parameter query to work.

Thanks in advance for anyones help

 

[Guest]

Try this --
Like [Enter Super] & "*" Or Is Null

 

[Guest]

Thank you for your quick response. Please let me give you a little more
info. When I entered the Or Is Null and I enter something in the Super
prompt, it returns all for that Super plus all the records that have nothing
in the Super field. What I am trying to accomplish is, when I enter
something in the Super parameter I only get records for that Super. When I
don't enter anything in the Super parameter, I will get records for all.
I apologize if I am confusing. Does this make any sense?
Thanks again,
--
JAD

Try this --
Like [Enter Super] & "*" Or Is Null

I have a query with two tables: Table1, Table2
The fields in the query are :

Field Region Super Date
Table Table1 Table2 Table2
Criteria [Enter Region] Like [Enter Super] & * Between [Beginning date] and
[End Date]

The query works fine if I enter all three parameters. If I enter only the
Region and Date parameters it will only return records that have a value in
the Super field, if will not return the records if the super field is blank.

I would appreciate instruction on how to get this parameter query to work.

Thanks in advance for anyones help

 

[Marshall Barton]

I have a query with two tables: Table1, Table2
The fields in the query are :

Field Region Super Date
Table Table1 Table2 Table2
Criteria [Enter Region] Like [Enter Super] & * Between [Beginning date] and
[End Date]

The query works fine if I enter all three parameters. If I enter only the
Region and Date parameters it will only return records that have a value in
the Super field, if will not return the records if the super field is blank.

In the OR line below the criteria:
Like [Enter Super] & *
add:
Is Null

 

[Guest]

Thank you. This works great.
--
JAD

I have a query with two tables: Table1, Table2
The fields in the query are :

Field Region Super Date
Table Table1 Table2 Table2
Criteria [Enter Region] Like [Enter Super] & * Between [Beginning date] and
[End Date]

The query works fine if I enter all three parameters. If I enter only the
Region and Date parameters it will only return records that have a value in
the Super field, if will not return the records if the super field is blank.

In the OR line below the criteria:
Like [Enter Super] & *
add:
Is Null