queries - changing dates

K

Kelly 1st

Hello,
I know this is a simple question...

I've made a query on a table asking it to bring me back say field 1 when it
= "yes", but also bring me back the date.

How do i make it so when i run the query, it asks me from what date i want
to look at...

Many Thanks
 
×

יריב החביב

on 'criteria' on your 'date' field in the query you have to write
[forms]![Tpatih]![monthdate]
Click to expand...

[Tpatih] - is the form

[monthdate] - is the textbox in the form where you will write the date you
want.
 
Top