Results 1 to 7 of 7
  1. #1
    PDilly is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    78

    Need help with graph in a form, to show hours booked for each day

    I help run a coarse fishery on behalf of a charity. Normally we issue annual season tickets. Job done.



    Because of the wretched Covid pandemic we like many others are having to do things very differently.

    The number of people allowed on site has been reduced to permit social distancing and maintain general public safety.

    We have a booking system in place which is working well. We allow 20 anglers on site on any day and they may stay on site for 12, 24, 36 or 48 hours. the start and finish times can be ignored as they are dealt with separately.

    The data I have to work with is the date their permit starts and the duration. Where I'm struggling graphically is with a duration that flows into the following day. in practice each single day can have a maximum of 20 people x 24 hours = 480 hours

    i.e. a 48 hour permit starts 08.00 on 1st June and runs to 08.00 3rd June. 3rd June can be ignored but I need the graph to show 1st and 2nd June as both having 24 hours taken up.

    It may be that I'm totally barking up the wrong tree. what my user wants to see is how many hours are used/vacant on any given day.

    any help would be most welcome

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Do all permits start at 8:00AM?

    Your daily max is 480 AnglerHrs.
    Your daily usage is sum(Permits*Hrs)/Day
    Your daily vacancy for a given day is Max Angler/Hrs -DailyUsageHrs
    The underlying constraint is Max 20 Anglers/day

    Perhaps you could show us your working/development database so we can see the issue.

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    I deal with graph issues best when I can work with data. If you want to provide db, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    PDilly is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    78
    Thanks Guys

    Bare bones of data attached.

    I know the graph is nonsense. My apologies, I never normally use them.
    all permits start 8am but arrival times are staggered which can be ignored.
    I'm not sure why the permit date has arrival time in it. it doesnt need it. I will check with the user, perhaps he wrongly thinks it needs to put it in.
    the constraints are as Orange has said in the earlier post.

    where I have struggled, is with permits rolling over two days. We have decided that for the purpose of calculating whether a day is full, a 36 Hour permit can be treated as 48 hours. we dont plan to allow site entry at 8pm.


    the purpose of the exercise is to indicate to the user that a day is full up, whether it be by permits booked for a specific day, or rolling over from the previous day. there is some wriggle room so it only has to be a visual guide to make him aware.Database1.zip

  5. #5
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Please have a look at the attached and let me know if that is what you wanted. You can also use the daily summary query on the form instead of the graph.

    Cheers,
    Vlad
    Attached Files Attached Files
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  6. #6
    PDilly is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    78
    Quote Originally Posted by Gicu View Post
    Please have a look at the attached and let me know if that is what you wanted. You can also use the daily summary query on the form instead of the graph.

    Cheers,
    Vlad
    Many thanks for taking the trouble to look at this for me Vlad.

    The daily summary is absolutely perfect

    I can now offer my user the choice of graph or figures.

    Very much appreciated

    regards
    Pete

  7. #7
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    You're very welcome Pete, yery glad to help a fellow fisherman !

    Cheers,
    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Replies: 2
    Last Post: 11-09-2015, 01:24 PM
  2. Replies: 2
    Last Post: 09-12-2014, 09:07 AM
  3. Only show data for past 4 hours
    By MFS in forum Queries
    Replies: 7
    Last Post: 02-28-2014, 02:45 PM
  4. Show employee's booked jobs in a calendar view
    By 11Edward23 in forum Forms
    Replies: 2
    Last Post: 01-06-2014, 08:51 PM
  5. Replies: 3
    Last Post: 01-10-2011, 10:31 AM

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