can anyone shed some light?

[Sam Summers]

Hi,

In my report i have created a group 'JobName' in which i have S/N (Control Source =1), JobNumber and JobName.

In the Detail section i have the records of personnel on each Job by JobID.

In the report footer i want to just display the number of Jobs but despite reading and trying various things i am still nowhere.

mainly i get the total of all personnel on every the jobs i.e. instead of 5 i get 42?

I tried =Count(*) and =Count([JobName]) and various other ways?

There must be a way to achieve this?

Thank you in advance

 

[pr2-eugin]

Did you try using DCount?

 

[EternalMyrtle]

I tried =Count(*) and =Count([JobName]) and various other ways?

You need to count on the Detail section because you want to count the number of employees doing a specific job, not on the Header section (i.e. JobName). Counting on the JobName header section will not yield the results you need.

Try going up into the Totals menu (see attached image). Select the field you want to total (probably employee name or unique identifier (JobID?), then select Totals>CountRecords as shown in the image. This will total up the number of employees doing a particular job and Access will automatically create the proper footer.

My report counts the number of boxes of books we have. The header section is for the book's title. The Detail section contains the individual boxes of books under a particular title heading (each box of books gets a unique item #). In this example, the record count is on the Item field in the Details section because I am trying to count the number of boxes we have for each title. You want to count the Details section because this is where the individual records are.

Does that make sense?

 

[Sam Summers]

Thank you for your reply.

OK, but my problem is that i have to display the percentages in the header section of my report? Is there a way to transfer the count from the detail section to the header?

 

[EternalMyrtle]

Yes, you can copy it into your group header section. Just follow the instructions and then do Ctrl+C on the count field and Ctrl+V into header and you will see.

 

[Sam Summers]

Still nowhere with this one,

I want to count the number of Jobs, not the employees?

 

[EternalMyrtle]

Did you try doing a count on the Job group header the way I showed you?? That should give you the number of jobs as it will only count the JobName control.

 

[EternalMyrtle]

Maybe it is not possible to count on a header. I just tried and nothing happened.

 

[EternalMyrtle]

Okay, something actually did happen: it totaled up everything as you said.

I think you need to take Paul's suggestion and try a DCount on the JobName field.

 

[EternalMyrtle]

For some odd reason, I was thinking about this question while swimming last night and realized that we never suggested that you try to do a count on the field in a totals query. That would be worth trying if you are still seeking a solution to this issue.