This is a very simple report:
The query grabs an Affiliation field with 5 choices as follows:
and a Date field where I ask the user to choose a Start date and an End
date with the following criteria:
Between [Please enter start date] And [Please enter end date]
The report displays only the Affiliation field, which shows up as a
Combo Box (rather than a textbox) because a lookup table is used to
populate this field.
I have 5 Unbound Textboxes with the Control Sources set as follows:
Because I want to get a count of the number of records returned for each
I am having 2 problems, as follows:
1) Each Unbound textbox is returning a count of Zero(0), as a numeric of
2) For some reason I am being asked to enter a parameter for the
Affiliation Combo Box after I enter the date criteria.
Please, tell me what I have done wrong.
Also, I would like to have the report display (in the report) the Start
Date and End Date that the user enters when running the report; if