creating a report using unbound fields

  • Thread starter Thread starter ayanda nkanyuza
  • Start date Start date
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
 
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".
 
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
 
HI

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

Please help me.
 
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",...
 
Back
Top