Results 1 to 5 of 5
  1. #1
    ACS Newbie is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    3

    Unhappy Scheduling database in Access

    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!

  2. #2
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    Are you working on a Form or a Report?

    255 Columns refer to a Table.

    What you may need is many Records not Columns.

  3. #3
    ACS Newbie is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    3
    Hi Rainlover.

    I need it for a table.

  4. #4
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    691
    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.

  5. #5
    ACS Newbie is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Posts
    3
    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
    Last edited by ACS Newbie; 01-21-2010 at 10:46 PM. Reason: Spacing

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Using ADO get access database name
    By sridhar in forum Database Design
    Replies: 1
    Last Post: 01-30-2010, 09:56 PM
  2. Using ADO get access database name
    By sridhar in forum Programming
    Replies: 0
    Last Post: 11-14-2009, 06:18 PM
  3. Access Database become inaccessible
    By samjoseph in forum Access
    Replies: 2
    Last Post: 07-01-2009, 01:01 AM
  4. Read only Access Database
    By Rameez in forum Access
    Replies: 7
    Last Post: 06-23-2009, 12:30 AM
  5. Remote database access
    By marleyuk in forum Programming
    Replies: 0
    Last Post: 01-15-2009, 01:43 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums