Action Query??

  • Thread starter Thread starter MurrayK
  • Start date Start date
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
 
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]
 
Back
Top