Prompt Queries and Partial Searches

  • Thread starter Thread starter Vince
  • Start date Start date
V

Vince

Hi,

I am creating a simple prompt query e.g. [Date?]

The current date format is 31-Jan-2003 as an example of
text formatting.

I noticed that their is no way for the user to enter in
partial searches?

e.g. jan* or 31*

How can I set up the query prompt to accept partial
searches which are possible on regular query without
prompts?

Newbie 911 please help.

Vince
 
Hi Vince:
All you have to do is put in the query Like "*" & [Date?]
& "*"

The user can put whatever in the parameter popup and the
asterisks act as wildcards.

Hope that helps.

Lillian
 
Hi Lillian,

Thx for the response but it still doesn't work?
Like "*" & [Date?] & "*"

When the prompt comes up I type in jan
the result is 0.

Please advise?
-----Original Message-----
Hi Vince:
All you have to do is put in the query Like "*" & [Date?]
& "*"

The user can put whatever in the parameter popup and the
asterisks act as wildcards.

Hope that helps.

Lillian
-----Original Message-----
Hi,

I am creating a simple prompt query e.g. [Date?]

The current date format is 31-Jan-2003 as an example of
text formatting.

I noticed that their is no way for the user to enter in
partial searches?

e.g. jan* or 31*

How can I set up the query prompt to accept partial
searches which are possible on regular query without
prompts?

Newbie 911 please help.

Vince
.
Click to expand...
.
Click to expand...
 
I might try the following.

Format(MyDateField,"mmmm dd yyyy") Like "*" & [Date?] & "*"

But this is probably not good method.
Hi Lillian,

Thx for the response but it still doesn't work?
Like "*" & [Date?] & "*"

When the prompt comes up I type in jan
the result is 0.

Please advise?
-----Original Message-----
Hi Vince:
All you have to do is put in the query Like "*" & [Date?]
& "*"

The user can put whatever in the parameter popup and the
asterisks act as wildcards.

Hope that helps.

Lillian
-----Original Message-----
Hi,

I am creating a simple prompt query e.g. [Date?]

The current date format is 31-Jan-2003 as an example of
text formatting.

I noticed that their is no way for the user to enter in
partial searches?

e.g. jan* or 31*

How can I set up the query prompt to accept partial
searches which are possible on regular query without
prompts?

Newbie 911 please help.

Vince
.
Click to expand...
.
Click to expand...
Click to expand...
 
Back
Top