Creating reports

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

Guest

I need assistance creating reports...

Ok, I have several tables that are in relationship with my main roster by
empNumb. the tables are employees and their training throughout the year. I
have created a report that has a parameter form popup when this report is run
based on EmpNumber and then the tables that are subreports in this report are
linked to the Emplnumber. This works great; however, i want to be able to do
a parameter form (by date) query that i can link all the trianing tables to
the master roster. So that when the supervisor wants a report on his
employee, all he has to do is type in the employee number then the beginning
and ending dates.

I know that this can be done, but i am so new at this i look like kermit the
frog.
Help.
Thank you in advance for the help.
 
Not sure how your subreports are designed, but you should be able to do this
with just one main report.

Create a query that returns all employees and their related training
records. Create an unbound form and add an entry control for empNum (combox
sourced from tblEmployee), and two date/time type controls (start+end). Use
the values of those controls as criteria for the above query. Add a command
button to that form to open the report (below).

Create a report and set its record source to that same query. Add a Group
for empNum and place the Employee Name, etc. in that band. Place the
training record info in the Details band.

Your users will enter their desired report criteria and click the command
button. The report will open after the query has run with criteria, and
display the desired records.
-Ed
 
Ed,

Thank you very much for your guidance...It is working; however, I have a few
gliches!

I hope you can help.

Ok, I created the query and in it i set criteria so that in the EmplNUm
field I put [FORM]![EmplNum] and in the first training date field I put
[FORM]![BETWEENDATE] AND [FORM]![ENDINGDATE].

When I open the form, I input employee number in its field, and then put in
the between date and ending date then click my command button. Okay well the
questions happen again [emplnum], [beginngdate], etc. Then the report comes
up great but then i look at the number of pages and I get hundreds and
sometimes thousands of pages of reports. I did a grouping on only the
emplnumber but also tried to set other areas with grouping and it did not
work. Can you help me figure out what is wrong with the report function of
this process?
Your help is greatly appreciated.
 
Back
Top