Prompt Queries and Partial Searches

[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

 

[Lillian]

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

 

[Vince]

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
.

.

 

[John Spencer (MVP)]

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
.

.