Saving Space Help

[Kerry Purdy]

Hi

I have a report which shows trainign course catering requirements

Date Rqd Resource Name Resource Option Resource Details
11/07/06 Lunch Buffet 1 veggie
option
11/07/06 Refreshments Danish
Patries @ 8am
12/07/06 Lunch Pub Garden BBQ
12/07/06 Refreshments
etc.....

This taking too much space on my report, some of our course could be 5 days
or more, am I able to change the display of my report to show

11/07/06 Lunch Buffet 1 veggie option Refreshments Danish Pastries
@ 8am
12/07/06 Lunch Pub Garden BBQ Refreshments
etc....

There will only be one Lunch and one Refreshment per day

I would appreciate some advise please.

Thanks very much for your time.

Kerry

 

[OfficeDev18 via AccessMonster.com]

Kerry,

Pattern your table structure after your report. I would change the structure
as follows:

DateRqd
LunchStyle
LunchMenu
RefreshmentStyle
RefreshmentMenu

Style and Menu items might be numeric, and the details might be in a
different table, for example:

tblLunchStyle

ID Desc
1 Buffet
2 Individual serving
etc.

tblRefreshmentStyle

ID Desc
1 you fill it in

tblLunchMenu
ID Desc
1 maybe a comprehensive list, or maybe a number that would refer to
another table that contains a comprehensive list.
etc.

Hope this helps,

Sam