queries - changing dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

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

Similar Threads

Converting Date Field to Month 7
query using an expression 7
date range in a query 2
Query criteria: field is empty 2
Query help 6
Select Queries 1
Really simple date query won't work ... aaaarrrrgghh 6
date format change when exporting 2

Back
Top