Help

[Admin]

I need some direction with a problem. I need to be able
to do a search from a search form where a user will enter
a date in format 12-Sept-04 in a text box and once the
command button is selected, it will search the database
to find any records which have values for the following
%C %H %N for the date entered in the textbox. The
records should show all records that have any values for
the above.

Much appreciate the HELP

 

[John Vinson]

I need some direction with a problem. I need to be able
to do a search from a search form where a user will enter
a date in format 12-Sept-04 in a text box and once the
command button is selected, it will search the database
to find any records which have values for the following
%C %H %N for the date entered in the textbox. The
records should show all records that have any values for
the above.

Much appreciate the HELP

Most people who post here want help about *something*. It's much
easier for the volunteers to pick out your question if you use a more
informative subject line, such as "Searching for a date value".

What do you mean by "the following %C %H %N"? Are these fieldnames
in your table, or what? I'm not at all familiar with the % syntax, and
I would never recommend using it in a fieldname!

To search three fields for a user-entered date, create a Query based
on the table; under each field being searched type

=[Forms]![NameOfYourForm]![NameOfTheTextbox]

using (of course) your own form and control names. Put these criteria
on *separate* lines so that Access will use OR logic.