Parameter Query - not working when on parameter not entered

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JAD - 27 Apr 2006 15:04 GMT

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

Signature

JAD

Reply to this Message

KARL DEWEY - 27 Apr 2006 15:30 GMT

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

> I have a query with two tables: Table1, Table2
> The fields in the query are :
[quoted text clipped - 11 lines]
>
> Thanks in advance for anyones help

Reply to this Message

JAD - 27 Apr 2006 15:37 GMT

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,

Signature

JAD

> Try this --
> Like [Enter Super] & "*" Or Is Null
[quoted text clipped - 14 lines]
> >
> > Thanks in advance for anyones help

Reply to this Message

Marshall Barton - 27 Apr 2006 16:21 GMT

>I have a query with two tables: Table1, Table2
>The fields in the query are :
[quoted text clipped - 7 lines]
>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

Signature

Marsh
MVP [MS Access]

Reply to this Message

JAD - 27 Apr 2006 16:35 GMT

Thank you. This works great.

Signature

JAD

> >I have a query with two tables: Table1, Table2
> >The fields in the query are :
[quoted text clipped - 12 lines]
> add:
> Is Null

Reply to this Message