Date Search

[jk]

I have a date such as JAN 1-15 in the middle of a text field and i would lie
to know how to set up the query that would bring out the results based on
this criteria.

 

[Duane Hookom]

Your requirements are very specific. You could set your criteria to:
Like "*JAN 1-15*"
I doubt very much this is a valuable reply.

 

[jk]

Thanks Duane,

I worked great. I am expecting this DB to grow and this field as described
would have text and some date typed within it. How would i set up a parameter
prompt that would work the same way when i want a specific date?

Thanks for all the help.

 

[Duane Hookom]

A parameter prompt can be set up like:
Like "*" & [Enter Date] & "*"

I don't care much for a design where a date isn't in a date field that can
be easily queried. Are you sure the date format will be consistent? What if
someone types in a date like "28 Apr 2007" or "4/28/2007" or "April 28, 2007"
or....?

I also don't care about parameter prompts. I prefer using control on forms.

 

[jk]

Thanks Duane,
End users know criteria format to be used will be jan 1-15 and nothing more
when added along with text into the field.I agree one hundred percent with
you but i have to work with what is given me and the parameter prompt for for
ease of use for them as well. Thanks

A parameter prompt can be set up like:
Like "*" & [Enter Date] & "*"

I don't care much for a design where a date isn't in a date field that can
be easily queried. Are you sure the date format will be consistent? What if
someone types in a date like "28 Apr 2007" or "4/28/2007" or "April 28, 2007"
or....?

I also don't care about parameter prompts. I prefer using control on forms.

--
Duane Hookom
Microsoft Access MVP

Thanks Duane,

I worked great. I am expecting this DB to grow and this field as described
would have text and some date typed within it. How would i set up a parameter
prompt that would work the same way when i want a specific date?

Thanks for all the help.