Scheduling database in Access

[ACS Newbie]

I am working on a database where I need to show the dates (for full year) as column headers, product as row headers, and qty produced as the field. Since access only allows 255 columns... is there any other way that I can achieve this other than dividing the year into different tables?


I also need to be able to sum all field entries per item.
Please help!

[Rainlover]

Are you working on a Form or a Report?

255 Columns refer to a Table.

What you may need is many Records not Columns.

[ACS Newbie]

Hi Rainlover.

I need it for a table.

[Rainlover]

That is not the correct way to go about it.

Use just One Field for the date and then use a crosstab query to display across the page.

Search CROSSTAB QUERY.

[ACS Newbie]

That is how I have it right now. Dates in one field. The problem is, I have to enter the dates for each item which takes more time. If I have the dates already set as column headers or fields, then it would be easier because all I have to do is enter the quantity produced per day for each item.

Here's a sample of what I am trying to do...

Item ----------1/10 -----1/11 -----1/12 ----- 1/13 ----- 1/14 ----- 1/15 ----> 12/31----- SumItem
Green Bag -------5--------- 3--------- 2 --------- 2 -------- 0 --------- 6 ----------------------- 18
Red Bag ---------1 -------- 4 -------- 1 --------- 1 --------- 3 --------- 2 ----------------------- 12
Yellow Bag ------ 0 -------- 2 -------- 0 --------- 3 --------- 5 --------- 4 ----------------------- 14
Sum Date ------ 6 -------- 9 -------- 3 --------- 6 --------- 8 --------- 12 -----------------------44

I also need to be able to get the sum per Item and sum per day....
I am doing this in access because it is linked to other tables rather than excel.
Hope this gives you a better idea of what I am trying to accomplish. Thanks