urgent please help

  • 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
 
ayanda said:
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
Click to expand...


Create a Totals type query grouped on the date field, which
better not be named Date, which is the name of an Access
built-in function. Use Sum for the lane fields.

Set the criteria for the date field to:

Between DateSerial(Year([Enter date]),Month([Enter date]),1)
And DateSerial(Year([Enter date]),Month([Enter date])+1,1-1)

This will pop up a prompt for a date, where you can enter
things like 4/2004 or April 2004.

Run the query and tweak it until it returns the desired
data.

The report can calculate lane grand totals by using text
boxes with an expression like:
=Sum([Lane 1])

I don't know what your Lane values represent, but it sure
sounds like a weak table design that should be redone to
properly normalize the data. (What are you going to do if
you ever need a Lane 5?)
 
Back
Top