Results 1 to 13 of 13
  1. #1
    Join Date
    Jul 2004
    Posts
    49

    Unanswered: query time from one table

    I have a table with several fields, one of which is a time field. On one report I need to pull several different time spans. How to do this? Several queries?
    For example, on the report will be afternoon: criteria is Between 12:00pm and 15:00 pm. Then night: Between 15:01 pm and 18:00 pm. I need about 5 different selections from the one table to show on one report. ...thanks for any help!

  2. #2
    Join Date
    Jan 2004
    Location
    Islamabad, Pakistan
    Posts
    97
    Seemingly You've 2 ways how to do this ...

    1. Either work out some way of grouping your data by creating grouping in your report and if your date and time field is there then you can group your data upon many options like year, Qtr. Month, Day, Hour or even minutes... check help for group on property of the report.

    2. Or create custume functions for filtering times according to morning, afternoon, or evening and use them in your query to filter values according to that and then use that query in your report to create what you want.


    - Saqib

  3. #3
    Join Date
    Jul 2004
    Posts
    49
    I don't see how I can group since they all have to be same type of grouping? And am not sure how to go about custom functions? Sorry I'm not that advanced?

  4. #4
    Join Date
    Jan 2004
    Location
    Islamabad, Pakistan
    Posts
    97
    can you send me the table on which you want that grouping and I'll see if something can be done?...

  5. #5
    Join Date
    Jul 2004
    Posts
    49
    Yes that would be very helpful...I don't see your email address anywhere?

  6. #6
    Join Date
    Jan 2004
    Location
    Islamabad, Pakistan
    Posts
    97
    upload your db to this post and I'll get it

  7. #7
    Join Date
    Jul 2004
    Posts
    49
    I sent email...did you receive?

  8. #8
    Join Date
    Jan 2004
    Location
    Islamabad, Pakistan
    Posts
    97

    Smile

    Yep!... I got it and now just give me some time to work on it... I get back to you soon. - Saqib

  9. #9
    Join Date
    Jan 2004
    Location
    Islamabad, Pakistan
    Posts
    97
    I've replied and sent back you my work. let me know if it worked for you...



    -Saqib

  10. #10
    Join Date
    Jul 2004
    Posts
    49
    Ok thanks much...now my email is down for some reason so as soon as it's up again I"ll look@!!

  11. #11
    Join Date
    Jul 2004
    Posts
    49
    Email back up but still nothing....

  12. #12
    Join Date
    Jan 2004
    Location
    Islamabad, Pakistan
    Posts
    97
    sent that file again to your email... did you receive it now?

  13. #13
    Join Date
    Jul 2004
    Posts
    49
    Yes thanks! Running out of time so may have to look at in the morning! I will get back to you and I really appreciate your help!

Posting Permissions

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