Question Locked

Count Field content without counting duplicates

0 helpful

2 replies

by luhamabwamooka May 27, 2008 last reply May 27, 2008

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to count field contents without counting null and duplicate fields in a report or query for a report using Microsoft Office Access 2003.

Say employee nickname: others dont have others share.

2 replies

Clarifications

select Count(*) From (Select distinct nickname from names where nickname is not null) dummyalias

is one way

This discussion is closed to new replies.