How to Count Unique Records in a Microsoft Access Database : Microsoft Office Tips

Subscribe Now:

Watch More:

Counting unique records in Microsoft Access is something that you can do by modifying your query properties. Count unique records in a Microsoft Access database with help from a longtime software expert and professional in this free video clip.

Expert: Brie Clark
Filmmaker: Alexis Guerreros

Series Description: Microsoft's Office still has the most powerful word processing, presentation, database and spreadsheet creation tools on any system available today. Get Microsoft Office tips with help from a longtime software expert and professional in this free video series.

[ironswhipp]

Incorrect! That is actually how to "display" unique records, not as titled, as there is no counting occuring.

[MuhammadImranimm]

you solve my problem in beautiful style

[PeterGMcDermott]

This is great, but is there any way to do this with Access Web Apps?

[miked]

That works great for 'detail' view. I'm trying to count unique records using the totals count option while hiding the detail view. Any idea?

[sethuramanm]

Here's my problem:

If a student gets a score of 49 and below in any subject, he won't be included in the ranking.Those students who will get above 49 in all subjects shall be rank according to their averageAnd if the students get an equal average, their ranks shall be equal.

[JamesLDurney]

Great for showing just the unique values, but doesn't show how to count how many of each of those values.

[Byrkster]

Software Expert! What the hell... definitely not an expert at all.

[GreekRetroGeek]

This is not how to count but how to display unique records.