Create Access Report with 2 detail blocks

[charboy]

I am trying to create a report that would appear to have two separate page header and detail sections. Is that possible? I have a simple query I'm pulling the data from. The query results looks something like this...

name address car year
joe 123 main street ford 1996
cindy 124 main street chevy 1997
larry 125 main street honda 1998

I'd like the report to look something like this...

name address
joe 123 main street
cindy 124 main street
larry 125 main street

car year
ford 1996
chevy 1997
honda 1998

but I can only get it to look like this...

name address
car year

joe 123 main street
ford 1996

cindy 124 main street
chevy 1997

larry 125 main street
honda 1998

 

[GingerR]

How about using sub-reports?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html