View Single Post
Old 06-10-2010, 10:09 AM   #1
ddmcmullan
Registered User
 
Join Date: Jun 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
ddmcmullan is on a distinguished road
Creating a report from Multiple Tables

If anyone can shed some light on this problem it would be a great help, I'm a bit of a novice on access so my problem may be easy to solve.

I am creating an access program for my dad's retail shop to create item signs (So everything is laid out nicely).

The tables I have are:
Package Sign: Package No (Primary, Autonumber), Total Price, Your Saving
Inventory: Package No, item description, item price
Options: Package No, option type, option price

Everything is linked to the package number pretty much with a one to one relationship.

I have the main form from table package sign and two subforms inventory and options.
From the main form I run a report which I would like to show:

Package No
Total Price
Your Saving

Option Type Option Price
Option Type Option Price
Opt .................................... etc

Item Description Item Price
Item Description Item Price
Item .................................. etc

At the moment when I run the report it joins all the information together and duplicates it, for example if I have two different option types it will duplicate by 2, 3 different option types duplicates by 3.

In actual fact I want the information to remain separated.

I've tried using the sub-form feature this lays it out how I want it but looks bad.

ddmcmullan is offline   Reply With Quote