ddmcmullan
New member
- Local time
- Yesterday, 21:41
- Joined
- Jun 10, 2010
- Messages
- 1
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.
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.