Street names report

[JanDG]

I didn't have a lot of lock with this in the Reports newsgroup so am trying
here.

I have a db of real estate sales which include the fields Subdivision and
Street Name.

I'm trying to design a report that will simply list the appropriate street
names under a particular subdivision. Although I can get it work by using
the "Hide Duplicates" property (the reason being that there will be several
sales on the same street) doing so results in large gaps in the report equal
in size to the number of sales on that street (i.e., if there were 10 sales
on Street A there would be a large gap between the Street Name A and the
next street name. If there was only 1 sale on Street B there would be no
gap between Street Name B and the following street).

I'm sure the answer is staring me in the face but can someone help me figure
out how to format the report so there are no gaps between the street names.

Thanks to all.

JanDG

 

[Ed Robichaud]

Create a "group" in your report for [SubDivision] and put the {subdivision]
field/control there (sort ascending). Put the [street name] field and
others in the "detail" section.
Check the Access help on report grouping for further info.
-Ed

 

[rowiga]

If I understand right, you have a subdivision named let's say Channelwood.
Within the subdivision you have several street names where sales have taken
place, let's say Elm Street, State Street and Cypress Blvd. Each of these
streets could have multiple listings. You only want to see each street name
ONCE on the report under the subdivision grouping even if Elm Street has 5
listings, State Street has 3 listings and Cypress Blvd has 125 listings.

Such as....

Subdivision CHANNELWOOD:
Elm Street
State Street
Cypress Blvd

If so, use the DISTINCT selection in your query.

"Select DISTINCT StreetName, Subdivision from MyTable......"