I am a total newbie to Reports and am completely stuck. I want to report on a Base qury that produces:
CatNo, CatDesc, ItemNo, Price There is a one to many relationship by CatNo to ItemNo I want the report to look like this: CatNo 1, Description1 Item No Price 1 9.99 2 8.99 CatNo 2, Description2 Item No Price 3 9.99 4 8.99 Etc. Can that be done? And if so how? When I use the Report Wizard I seem only to be able to group on CatNo and CatDesc goes to the item lines. TIA Gert --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
