Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    10

    Red face Unanswered: Little Help need here with Dates and Reports

    I hope this makes sense.......

    What I need to do is set up a report so that it will give me the number of accidents for a given year and month. I already have the report set-up to give me the total number of accidents I have and the total cost of the accidents now I need for it to give the month in which these costs occured. Can I do this and if so please help me.


    The following are the feild that I am using

    Cost
    Accident Code
    Location
    Area
    Date incident Occured

    Please help me!!!

  2. #2
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    I am not too familar with thisd, but its in that sorting and grouping window again. I saw that there is some different GroupOn levels...Year,day,month, hour, minute. Can you post a sample DB with the data? I can spend a few moments on it
    Ryan
    My Blog

  3. #3
    Join Date
    Sep 2003
    Location
    Caldes de Malavella, Spain
    Posts
    244
    Hi Mandee,

    Put the table into a new query, and add your fields. Create a field which reads:

    MonthOfIncident:Format([Date Incident Occurred[],"mmmm yyyy").

    This will give you, when you run the query, something like:

    August 2004

    or if you use

    Format([Date Incident Occurred[],"mmm yyyy")

    it will give you

    Aug 2004.

    Check Help for info on the Format property to learn more.

    Hope this helps
    Andy Briggs
    Elmhurst Solutions Limited
    Database Development and Consultancy
    http://www.elmhurstsolutions.com

  4. #4
    Join Date
    Sep 2003
    Location
    Caldes de Malavella, Spain
    Posts
    244
    Sorry, typo: should read

    "Check Help for info on the Format function to learn more."
    Andy Briggs
    Elmhurst Solutions Limited
    Database Development and Consultancy
    http://www.elmhurstsolutions.com

  5. #5
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    Relook at your statement again Andy...
    Quote Originally Posted by AndyBriggs
    Format([Date Incident Occurred[],"mmm yyyy")
    Shouldn't that give an error because you never fully closed it??
    Ryan
    My Blog

Posting Permissions

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