Results 1 to 5 of 5

Thread: Report By Date

  1. #1
    Join Date
    Nov 2002
    Posts
    6

    Question Unanswered: Report By Date

    I have a database with records that cover several years. I would like to do a report/query that summarises the data by count the number of cases for each year. How can I do this?
    I'm using Access 97.

  2. #2
    Join Date
    Jan 2003
    Posts
    46
    Access reports have a powerful capability through "Sorting and Grouping".

    In report design view, right click on the detail section and then select sorting and grouping. You need to set the grouping property on the year field.

    Cheers,
    Zambezibill

  3. #3
    Join Date
    Jan 2003
    Posts
    46
    Sorry, but I misread your question. To count the number of cases,;

    1) Create a query with the Year field and the ID field.

    2) In query design view, right click on the ID field.

    3) Select "Totals".

    4) Then click on the totals dropdown and select COUNT.

    Cheers,
    Zambezibill

  4. #4
    Join Date
    Nov 2002
    Posts
    6
    Yeah, that's the sort of thing I want. But the problem is, the date is stored dd/mm/yyyy, and I don't know how to group them just by the year

    Cheers,
    Alkibiades

    Originally posted by zambezibill
    Sorry, but I misread your question. To count the number of cases,;

    1) Create a query with the Year field and the ID field.

    2) In query design view, right click on the ID field.

    3) Select "Totals".

    4) Then click on the totals dropdown and select COUNT.

    Cheers,
    Zambezibill

  5. #5
    Join Date
    Sep 2002
    Location
    Land of OZ
    Posts
    173
    Originally posted by Alkibiades
    Yeah, that's the sort of thing I want. But the problem is, the date is stored dd/mm/yyyy, and I don't know how to group them just by the year

    Cheers,
    Alkibiades
    1) Create a query with the ID field.

    2) Then in a blank column type TheYear:Year(DateFieldName) .... this will give you just the year from the date field

    3) In query design view, right click on the ID field.

    4) Select "Totals".

    5) Then click on the totals dropdown and select COUNT for the ID field

    Cheers
    Mona
    ________________________________
    Life is too short to be sane or sensible. Weird people rule and normal people suck

Posting Permissions

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