refer to a summarised field which doesnt appear on the report

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

Guest

I am trying to create a report of staff qualifications. I have created the
first step in that I can count how many employees have particular
qualifications at a particular locality. However, I now want to express this
number as a percentage of the total employees at a locality. How do I get the
total number of employees at the localities?
The structure is as follows. Employeedetailstbl holds names of employees;
postdetailstbl holds info on the post and projectcodestbl holds the location
and locality of the post. I have created a report which quite rightly
calculates the number of employees at a particular locality.
I then want this number to be referred to in the qualifications report as
the total number of employees at that locality.
How do I do this? It seems it should be simple, but I just cannot get my
head round it!
Can anyone help?
 
Lynn:

One alternative is to use the DCount function. This function allows you to
obtain a count from a table or query that is separate from the report. You
can use the criteria parameter of the DCount function to specify which
location to do the count on. You may be able to use the query/table behind
your other report, depending on its structure. Access help has more
information on how to use this function.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am trying to create a report of staff qualifications. I have created the
first step in that I can count how many employees have particular
qualifications at a particular locality. However, I now want to express this
number as a percentage of the total employees at a locality. How do I get
the
total number of employees at the localities?
The structure is as follows. Employeedetailstbl holds names of employees;
postdetailstbl holds info on the post and projectcodestbl holds the location
and locality of the post. I have created a report which quite rightly
calculates the number of employees at a particular locality.
I then want this number to be referred to in the qualifications report as
the total number of employees at that locality.
How do I do this? It seems it should be simple, but I just cannot get my
head round it!
Can anyone help?
 
OK, but how do I specify the criteria? I want to summerise the number of
employees at each location, not just one location at a time. Is this possible
to do this?
 
Lynn:

Your original post refers to calculating the percentage for a particular
locality. The DCount function will do this for you by providing the total
count for a locality.

To summarize the number of employees at each location, you could create a
subreport (or a separate report) with an appropriate Group By query where
you group on locality and use the Count function to count the number of
employees.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


OK, but how do I specify the criteria? I want to summerise the number of
employees at each location, not just one location at a time. Is this
possible
to do this?
 
Still struggling!
I have a separate report which does count the number of employees at each
locality. I want to display or use these totals in the calculation on the
main report. How do I do this?
 
Lynn:

To display the totals, you can use a subreport. It is a control just like a
textbox, etc. You can set the SourceObject property on the subreport to the
name of the report that contains your totals. Once you create a subreport
in the main report, you can use the total values in the subreport by
referencing the textboxes according to the following MS KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209099

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Still struggling!
I have a separate report which does count the number of employees at each
locality. I want to display or use these totals in the calculation on the
main report. How do I do this?
 
Back
Top