Results 1 to 2 of 2
  1. #1
    g4tv4life is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2014
    Posts
    50

    Complex problem, hopefully a simple solution?

    Hey everyone, I have a nasty query i'm trying to create here, here's the basics of it:



    We have a system that facilities respond 3 times a day with stock. These reports have to come in very specific windows. Morning 2-6,Afternoon 8-12, and night 4-8
    Some days, facilities respond 4 times a day, other times 3, other times 2. What I want to eventually do create monthly charts showing the % of compliance of the 3
    time windows.

    The data comes out as excel with the facility name and the time/date(in a single column) of the report Example:
    FACILITY DATETIME
    blarg 3/1/2014 4:56

    I'm thinking my first step should be to convert this into a format like this:
    FACILITY DATE WINDOW1 WINDOW2 WINDOW3
    blarg 3/1/2014 YES NO YES

    The tricky part is, making a query smart enough to tell if any of the values for a day fall in each window and not get confused if they're extra values. Any Ideas?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,518
    Don't do it as you are suggesting.

    Create a more detailed description of what is involved; what are the main things involved? How do these things interact/interrelate?What exactly do you want to record? What exactly do you have to Report? Is the some regulation/law/statute that Facilities must adhere to/abide by?

    Do Facilities have Contacts/Agents that interact with you/your Company? If so, do these change? If so,is it important who does whatever a facility does?

    You need some meat on the skeleton you provided. The secret to database is to get it designed --up front -- to support the business and business rules.

    If you haven't worked with database, then here's a tutorial that will guide you through the steps and create a well designed database.Once you have worked through it and compared your solution with the tutorial's example, you'll be in great shape to apply what you've learned to your own database.

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

Similar Threads

  1. Replies: 2
    Last Post: 10-12-2013, 11:17 AM
  2. Simple stock keeping solution
    By Count Duckula in forum Database Design
    Replies: 5
    Last Post: 06-11-2013, 09:03 AM
  3. Probably a simple solution, but driving me nutz!
    By Bribie4507 in forum Queries
    Replies: 3
    Last Post: 02-22-2013, 07:10 PM
  4. Probably a simple solution, but I am stuck
    By ANC-AB in forum Queries
    Replies: 3
    Last Post: 04-29-2012, 10:05 PM
  5. Replies: 2
    Last Post: 08-26-2009, 10:43 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 - Senior Forums