Adding dates from a query to a form

  • Thread starter Thread starter DRSmith
  • Start date Start date
D

DRSmith

Guest
Any help you could give me with this would be greatly appreciated.
I have a query in which I want to know how many people responded to a particular survey question.
The three fields in the query are:
CustomerNum, SurveyDate, Response
In the query I ask the question:
Between[Enter beginning date:]and[Enter ending date:]
And in this particular query in the Response area, I look for the criteria "Yes". To get the range of dates the question is being asked.
On the resulting form, I want to be able to have that beginning date and ending date appear so that the users can see the range of dates the question was asked.
Can anyone suggest a way that I can accomplish this?

Thanks much!
D. Smith
 
Access help topic: reports, criteria to select data to include

You need to create a form that allows the user to input the criteria so that it can be later referenced by the report. You have the query look to the form for the criteria:
Between Forms![Frm_PickDates]![BegDate] and Forms![Frm_PickDates]![EndDate]
You base the RecordSource of the report on the query. In the OnOpen event of the report, you open the form (Frm_PickDates) It's kinda crazy to think about, but VERY cool to use.
 

Users who are viewing this thread

Back
Top Bottom