hello,
here is the situation, I have parts that rollup to specific Products, and I created a query that represents the complete relationship and have created a report using the wizard and I get the correct information, but I want to have the following:
Product, Product description (Same level)
Parts. and part information
How do I move the fields around without always having the columns locked. and How do I move the Description to follow the Product. (This is a 1:1 relationship in the products table)
Thanks
Steve
Here are the screen shots to explain a little better.