By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,544 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Access report count function

P: n/a
Hello I am new to access, I have a report that has a list of classes in
the section that is called class header. I want to count how many
classes are on my report? and then divide this by another feild in my
class footer? can this be done?
Thanks Annette

Apr 25 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Br
cajan341 wrote:
Hello I am new to access, I have a report that has a list of classes
in the section that is called class header. I want to count how many
classes are on my report? and then divide this by another feild in my
class footer? can this be done?
Thanks Annette


Create a textbox and give it a controlsource of

=Count([myClassField]) / [myOtherField]

Ideally you'd want to deal with Div/0 errors too...
--
regards,

Br@dley
Apr 25 '06 #2

P: n/a
Thank You

This worked.

:) Annette

Apr 26 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.