Problems with Sub Report

[crhodus]

I know this is something simple that I am overlooking and I've corrected this problem before with other reports in the pas, but I gone totally blank.

The detail section of my report will display the Company Name. Also in the detail section is a subreport that contains DestCity, OverNight, and NonOverNight.

When I run the report, it displays every combination of city that is possible. I dont want this, I only want it to display the names of the city once.

Here is an example of what is happening. Hopefully this will clarify what is happening.

(Please ignore lines, used just for formatting on forum.)

Company DestCity OverNight NonOvernight
Acme Co. Dallas__ Washington Boston
________Dallas__ New York__ Boston
________Dallas__ Washington Vicksburg
________Dallas__ New York__ Vicksburg
________Houston Washington Boston
________Houston New York__ Boston
________Houston Washington Vicksburg
________Houston New York__ Vicksburg

This is what I want Displayed:

Company DestCity OverNight NonOvernight
Acme Co. Dallas__ Washington Boston
________Houston New York__ Vicksburg

I just want it to list all cities under their appropriate column heading.
Can anyone help with the maddness that I just typed in?

Thanks in advance!

[This message has been edited by crhodus (edited 10-08-2001).]

[This message has been edited by crhodus (edited 10-08-2001).]

[This message has been edited by crhodus (edited 10-08-2001).]

[This message has been edited by crhodus (edited 10-08-2001).]

[This message has been edited by crhodus (edited 10-08-2001).]

[This message has been edited by crhodus (edited 10-08-2001).]

 

[crhodus]

Hi Pat,

I checked to see if there were any tables that did not relate, like you said and I saw where either I or Access joined two tables in my query that should not have been joined together.

Thanks!