ACCESS 2007 HOW TO DISPLAY TABULAR DATA AND EXPRESSION RESULTS

[nerbonne]

Hi,

I'm starting to use Access 2007. I'm pretty good with Excel but Access is new to me. I've figured out how to use a query to display a list of unique date in my table, but what I want to is display a second row that has a count of how many times the unique value occured. I know how to use dcount to get that number, but I don't know how to display the unique value and the result of the dcount expression as well.

Any help is much appreciated.

 

[SkipVought]

A second ROW? Don't you mean a second COLUMN?

select [YourDateField], Count(*) as DateCount
From ....

Group By [YourDateField]

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]