Wildcards & * including null values

[Bez]

I have created a querie from a Form with differents search criteria on
the form when i search for a comopany begining with "a" for example it
will bring up all the companies begining with "a" but if the values is
blank it will not include it

the same happens with any of the other values

Please help so I can bring up the empty boaxes as well

This is what my criteria line looks like.
Like [Forms]![query form del]![Company Name] & "*"

[Keith Wilby]

"Bez" <be*********@awareness-group.com> wrote in message
news:11*********************@f6g2000cwb.googlegrou ps.com...

I have created a querie from a Form with differents search criteria on
the form when i search for a comopany begining with "a" for example it
will bring up all the companies begining with "a" but if the values is
blank it will not include it

the same happens with any of the other values

Please help so I can bring up the empty boaxes as well

This is what my criteria line looks like.
Like [Forms]![query form del]![Company Name] & "*"

Have you considered using the built-in "filter by form" utility?

Regards,
Keith.

[RoyVidar]

Bez wrote in message
<11*********************@f6g2000cwb.googlegroups.c om> :

I have created a querie from a Form with differents search criteria
on the form when i search for a comopany begining with "a" for
example it will bring up all the companies begining with "a" but if
the values is blank it will not include it

the same happens with any of the other values

Please help so I can bring up the empty boaxes as well

This is what my criteria line looks like.
Like [Forms]![query form del]![Company Name] & "*"

Try something like this

(yourfield Like [Forms]![query form del]![Company Name] & "*" or
[Forms]![query form del]![Company Name] is null)

--
Roy-Vidar

[Allen Browne]

Switch your query to SQL view.
Locate the WHERE clause.
Change it to something like this:

WHERE (([Forms]![query form del]![Company Name] Is Null) OR
[Field1] Like [Forms]![query form del]![Company Name] & "*"))

If you are doing this with lots of fields, it gets inefficient. You might
like to remove the criteria from the query, and instead build a filter
string from only those boxes that have something in them. You can then apply
this as the Filter of a form, or as the WhereCondition of OpenReport.

If you understand a little VBA, and want an example of that technique, grab
this sample database:
http://allenbrowne.com/unlinked/Search2000.zip
Requires Access 2000 or later.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bez" <be*********@awareness-group.com> wrote in message
news:11*********************@f6g2000cwb.googlegrou ps.com...

I have created a querie from a Form with differents search criteria on
the form when i search for a comopany begining with "a" for example it
will bring up all the companies begining with "a" but if the values is
blank it will not include it

the same happens with any of the other values

Please help so I can bring up the empty boaxes as well

This is what my criteria line looks like.

Like [Forms]![query form del]![Company Name] & "*"

[Bez]

Keith Wilby wrote:

"Bez" <be*********@awareness-group.com> wrote in message
news:11*********************@f6g2000cwb.googlegrou ps.com...

I have created a querie from a Form with differents search criteria on
the form when i search for a comopany begining with "a" for example it
will bring up all the companies begining with "a" but if the values is
blank it will not include it

the same happens with any of the other values

Please help so I can bring up the empty boaxes as well

This is what my criteria line looks like.
Like [Forms]![query form del]![Company Name] & "*"

Have you considered using the built-in "filter by form" utility?

Regards,
Keith.

i don't know what that is ??

bez

[Bez]

this doesn't work just tried it after i got your message
RoyVidar wrote:

Bez wrote in message
<11*********************@f6g2000cwb.googlegroups.c om> :

I have created a querie from a Form with differents search criteria
on the form when i search for a comopany begining with "a" for
example it will bring up all the companies begining with "a" but if
the values is blank it will not include it

the same happens with any of the other values

Please help so I can bring up the empty boaxes as well

This is what my criteria line looks like.
Like [Forms]![query form del]![Company Name] & "*"

Try something like this

(yourfield Like [Forms]![query form del]![Company Name] & "*" or
[Forms]![query form del]![Company Name] is null)

--
Roy-Vidar

[RoyVidar]

Bez wrote in message
<11*********************@f6g2000cwb.googlegroups.c om> :

this doesn't work just tried it after i got your message
RoyVidar wrote:

Bez wrote in message
<11*********************@f6g2000cwb.googlegroups.c om> :

I have created a querie from a Form with differents search criteria
on the form when i search for a comopany begining with "a" for
example it will bring up all the companies begining with "a" but if
the values is blank it will not include it

the same happens with any of the other values

Please help so I can bring up the empty boaxes as well

This is what my criteria line looks like.
Like [Forms]![query form del]![Company Name] & "*"

Try something like this

(yourfield Like [Forms]![query form del]![Company Name] & "*" or
[Forms]![query form del]![Company Name] is null)

--
Roy-Vidar

Oh - it does indeed usually work, it's a bit of a standard thingie,
this, see - I'm just sorry to report that there seems to be some clouds
or fog in my crystal ball at the moment, so I'm not able to comment on
why it doesn't work in your setup ;-) you do work in the sql view of
the
query, don't you?

But do also follow Allen Brownes link for another version, or try a
search in the NG for more/other options.

--
Roy-Vidar