counting hidden (duplicate) values

K

Karina M ;)

Is it possible to perfrom a count of values hidden (I chose to hide duplicate
values) in a report? If so, what would the formula look like?
Thanks!
 
D

Duane Hookom

My experience is that duplicates are always counted. Normally users come here
to ask how NOT to count duplicate values.
 
K

Karina M ;)

Not counting duplicates will also resolve my problem. The query pulls all the
info and the report omits the duplicate values (work order #) in a record but
still shows the rest of the details of the record (site name, dates, etc.) in
the report. Can I omit counting the "blank/hidden" duplicate work order
numbers although a record still exists for this work order? Let me know if
you need additonal info to respond. I've been using Access for a few years
but am not good with formulas or SQL so please explain as simply as possible.
Thanks!
 
D

Duane Hookom

Please ask again with greater clarification. Do you want to count all the
records or just the unique values of a field? Do you wan this in a group
footer or report footer?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate fields count as one. 7
Count Function (conditional counts) in Reports 3
Not display repeated values in a field 2
Count the columns from one sheet and paste it in another sheet 0
Exclude Hidden Row Values 4
Hiding duplicate values of a field in an Access Report 1
Counting Unique Data in Report 1
Sum If 1

Top