calculating final totals of data entered in individual records

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

Guest

I have created a database that is broken down into job series, i.e., 0401,
0404, 0480. I am trying to calculate the total sum of the yes/no box that
identifties the applicants race/sex, i.e., EM, EF, CM, CF. I am trying to get
total counts of the race/sex from one series at a time.

In addition, part of my form totals are complete, but I need 1 record of the
accumulated individual records for one job series at a time, i.e., 0401. When
I look at my form it breaks down all the 0401 into separate records and
separate totals as it applies to that one individual record entered.

How do I create the query that represents ONE report based on all the
entries made for ONE job series.
 
stacy said:
I have created a database that is broken down into job series, i.e.,
0401, 0404, 0480. I am trying to calculate the total sum of the
yes/no box that identifties the applicants race/sex, i.e., EM, EF,
CM, CF. I am trying to get total counts of the race/sex from one
series at a time.

In addition, part of my form totals are complete, but I need 1 record
of the accumulated individual records for one job series at a time,
i.e., 0401. When I look at my form it breaks down all the 0401 into
separate records and separate totals as it applies to that one
individual record entered.

How do I create the query that represents ONE report based on all the
entries made for ONE job series.
Click to expand...


I am not sure I understand exactly what you have and what you want, but
I will guess that you need to filter (use criteria in a query) the data to
whatever job series you want.
 
Back
Top