Action Query??

M

MurrayK

hey,

How do I create an Input box so I can put my dates in the query?
have a field called ShipmentComplete and I want an Input box so I coul
enter the between dates ie. between #1/1/04# and #1/31/04#. I'm usin
a make-table query because I'm counting/manipulating the data from th
query. Can anyone help me? I'm using Access 97.

Thanks,
Ken:confused
 
S

Steve Schapel

Ken,

You can use a Parameter Query, so in query design view, you put
something like this in the criteria row of your date field in the query
design grid...
Between [enter date from] And [enter date to]
which will result in you being prompted to enter the dtaes whenever the
query is run.
I much prefer the approach of putting two unbound textboxes on a form
which will be open at the time that the query is run, where you can
enter your befinning and ending dates prior to running the query. And
in the criteria of your date field, put the equivalent of...
Between [Forms]![FormName]![DateFrom] And [Forms]![FormName]![DateTo]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top