Simple question (book at home)

[JanDG]

Help!

I can't remember how to show a field only once when that field appears
multiple times in the query.

Specifically, I'm preparing a report showing the streets within a
subdivision based on a query which returns several sales on a particular
street (say Jones Street).

What I want is a report grouped under the subdivision name with Jones Street
shown only once not with Jones Street repeated for every seperate sale on
Jones Street.

I know this is easy but I haven't done it in a while and my Access books are
at home!

Thanks to all.

JanDG

 

[Brenda@DMS]

Help!

I can't remember how to show a field only once when that field appears
multiple times in the query.

Specifically, I'm preparing a report showing the streets within a
subdivision based on a query which returns several sales on a particular
street (say Jones Street).

What I want is a report grouped under the subdivision name with Jones Street
shown only once not with Jones Street repeated for every seperate sale on
Jones Street.

I know this is easy but I haven't done it in a while and my Access books are
at home!

Thanks to all.

JanDG

Create the report and group it by Subdivision, then by street. Then make the sales field a sum of all sales for that street (Ex. =SUM([SalesAmt]) Hope this helps!