Ms access

[aerosmith2k1]

Good Evening, I'm new to access besides what i did in highschool :), My issue is i have to crosstab's in which i want to make a report out of, to look something like this. Report 1. Heading.query1 heading.query1 heading.query1 heading.fromquery2 headingfromquery2 name value value value value name value value value value name value value value value My issues is, in design view, i can create a report only with the first query, If i choose the data itms from the 2nd query i lose the first items i already put, with errors saying the item does not exist. Is there an easyerway? I appreciate the assistance, Thanks,

[Wendelius]

This possibly is a join but based on the info it's hard to say. Could you give few example rows from the tables and an example what the report would look like with that data.

The need to optimize rises from a bad design.My articles[^]