hardin4019
Registered User.
- Local time
- Today, 11:21
- Joined
- Apr 28, 2010
- Messages
- 15
Hi Guys,
Still feeling very much like a newbie. (In case it matters) I am using MS Access 97...
So I have a form that has different buttons each to a slightly different report, and now I am going to the extra step of adding a combo box next to each.
1st report, employee attendance grouped by SupervisorName (added a Supervisor ComboBox so I can run a report by supervisor and not the entire group of supervisors)
2nd report, employee attendance grouped by Employer (added a Employer ComboBox so I can run a report by employer (we have both our own employees and temporary contract employees)
3re report, shortened version of 2nd report, doesn't show detail of each abscence.
Dilemma, I found a great tutorial on how to make the parameters of a query bound to a control in a form. Problem is, all 3 of the above reports have the same data set collected from the same query. So if I don't choose an Employer, and run the 1st report, I get nothing, and like wise, if I run the 3rd report but don't pick a supervisor, I get nothing, and when I do pick a supervisor, I get only a fraction of what I should get.
Is there a way to say that if the value in the combo box is null, then select all available records, or am I better off making each report run from a slightly different query? I would still really like it that if I didn't pick a Supervisor Name or Employer and ran either report, it showed all the data gathered in the query.
Still feeling very much like a newbie. (In case it matters) I am using MS Access 97...
So I have a form that has different buttons each to a slightly different report, and now I am going to the extra step of adding a combo box next to each.
1st report, employee attendance grouped by SupervisorName (added a Supervisor ComboBox so I can run a report by supervisor and not the entire group of supervisors)
2nd report, employee attendance grouped by Employer (added a Employer ComboBox so I can run a report by employer (we have both our own employees and temporary contract employees)
3re report, shortened version of 2nd report, doesn't show detail of each abscence.
Dilemma, I found a great tutorial on how to make the parameters of a query bound to a control in a form. Problem is, all 3 of the above reports have the same data set collected from the same query. So if I don't choose an Employer, and run the 1st report, I get nothing, and like wise, if I run the 3rd report but don't pick a supervisor, I get nothing, and when I do pick a supervisor, I get only a fraction of what I should get.
Is there a way to say that if the value in the combo box is null, then select all available records, or am I better off making each report run from a slightly different query? I would still really like it that if I didn't pick a Supervisor Name or Employer and ran either report, it showed all the data gathered in the query.
