Hi,

I am working on a database for my boss and he wants to be able to enter the weekly sales figures per customer on a daily basis.

He wants to see the full week at all times so the design would look like

Week Commencing 1st November 2003

01 02 03 04 05 06 07
SUN MON TUE WED THU FRI SAT TOTAL
product 5 0 1 12 22 4 11 55
product
product
etc etc


Is this type of design possible?
Any suggestions / help / ideas / SOLUTIONS to this would be great.

Regards

Mogsy