D
Don Rountree
I have an Access database in my fpdb folder. The database
is populated by user input through a page in my web.
There is another page where management can enter a date in
a one line text box and search the database and have all
records returned that match that date. What I want to do
is this. Instead of the user keying in the date which
must be entered in a "mm/dd/yy" format, I want a drop down
text box that has dates matching those in my database that
are Between DATE()-15 And DATE()+5. This means there will
always be 20 days to searh in the database. I created a
second query in my database with criteria that creates the
date range I need. The actual search uses another query.
How can I get the search page to let me select from the
Date query but return results from the Results query?
I've seen web pages that list database results as a search
criteria so I know this can be done, I just don't know how
to do it. Any help would be appreciated.
Don Rountree
is populated by user input through a page in my web.
There is another page where management can enter a date in
a one line text box and search the database and have all
records returned that match that date. What I want to do
is this. Instead of the user keying in the date which
must be entered in a "mm/dd/yy" format, I want a drop down
text box that has dates matching those in my database that
are Between DATE()-15 And DATE()+5. This means there will
always be 20 days to searh in the database. I created a
second query in my database with criteria that creates the
date range I need. The actual search uses another query.
How can I get the search page to let me select from the
Date query but return results from the Results query?
I've seen web pages that list database results as a search
criteria so I know this can be done, I just don't know how
to do it. Any help would be appreciated.
Don Rountree