creating a report using unbound fields

A

ayanda nkanyuza

Hi

Please help me create a report.
My table has LANE 1 to 4
DATE
Other details

I would like to create a report like this

Lane 1 Lane 2 Lane 3 Lane 4
Day 1 Total Total Total Total
Day 2
......
Day 31 depending on the supplied month

I also do not know jhow to supply the month and create the days for the
supplied month

Also grand totals per lane

Please help
 
D

Duane Hookom

How do we know what is Day 1 vs your DATE field? Do you really have four
fields for lanes? If so, do you understand that this isn't normalized
properly?

If you have four lane fields then you should be able to spread them across
your detail section as per your "like this".
 
A

ayanda nkanyuza

Hi

I do not know much about normalization
But the days are just 31/30/29/28 days of the month supplied.

Please help I do not have a clue.

Ayanda
 
A

ayanda nkanyuza

HI

I forgot to tell you that I have only one filed for the lanes.

Please help me.
 
D

Duane Hookom

I see you began another thread. You better go back there and provide some
sample records so Marsh understand there is only one "Lane" field with
values of 1-4. He thinks you have field "Lane1", "Lane2",...
 
Top