Solved

cnt function

Posted on 2006-11-10
5
341 Views
Last Modified: 2006-11-18
What's the purpose of cnt() functions that is used in calculation in queries or reports

example

cnt(sum("field name")
0
Comment
Question by:maximyshka
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 5

Expert Comment

by:sinjin
ID: 17918059
I have not heard of a CNT function... could it be a variable name?

 - sinjin
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 17918097
Double-click on the cnt, then right-click:Definition, and see what pops up.

Either cnt is a function/sub used by another object model not commonly used in Access, or it is a custom public function/sub.
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 17918100
Or as sinjin posted above a variable, perhaps an array.
0
 

Author Comment

by:maximyshka
ID: 17918166
It is used in report footer (report created by someone else)

=Sum(cnt([OCL]))

OCL is one of the fields in table.  I don't think definition will work there
0
 
LVL 66

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 17918179
Perhaps the previous developer intended to type =Sum(Count([OCL])), and made a mistake.

One way to know for sure, hit your {f2} key to go to the Object Browser, search for cnt, and see what it finds.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question