Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006

    Unanswered: How do I create tables in the same database for different months ?

    hello everyone,

    I would like to know how can I integrate monthly data into the same table & be able to classify/ sort data based on the months ? Is this possible in Access ? Thanks so much.....


    Crystal Carr.

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    SELECT whatever
    FROM yourTable
    GROUP BY yourMonth


    SELECT whatever
    FROM yourTable
    ORDER BY yourMonth

    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Dec 2004
    Madison, WI
    As far as integrating the data into 1 table, just create a date type data field (i.e. DateToCount or MonthToCount). You can designate your records separated by month as the first day of each month, the last day of each month, or the actual date of something on each record (however you want to count it.) Then use Teddy's sql statements to retrieve the records grouped by date (which can be formatted by months).

    You want to have your Month type of field defined as a Date data type. This way you can do date ranges in the criteria for your query, change the date range and re-use the same query/SQL statement.
    Last edited by pkstormy; 10-05-06 at 15:06.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts