Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    First you talk about Time and Attendance and now Sales database. Your questions are too broad. I am not going to try to talk you through the multitude of steps required to build a database. If you "have very good concept about how to create tables , forms, and report" then you should know how to build a form/subform arrangement.



    Should not 'update' a table with remaining quantity. Quantity on hand should be calculated when needed.

    Perhaps you should download the Northwind database template and learn from it. It might even be suited to your needs as is. There are even TimeCard and Time & Billing templates. Hopefully, in 2013 you can still find them by: File > New > Database > choose from assortment.
    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.

  2. #17
    Slurry Pumper is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2016
    Posts
    28
    I just read this, and now I am bummed to all extents. The lack of a CountIf function is also problematic for me as I would like to link my excel spreadsheet into an access database. My spreadsheet is keeping track of wins / losses / and ties of NFL games since 2002. I have my excel spreadsheet keeping track of several items and 1 of those items or shall I say the most important item is the wins, losses, and ties as they relate to the vegas line. I haven't read up on the union query as of yet, but I was wondering if, perhaps my excel spreadsheet also has all of the particular information needed in separate columns to calculate the wins and losses, is it possible to utilize the Sum and If functionality in some combination to parse out the wins losses and ties to separate areas in the report.


    In my excel sheet, I keep a columns of the "Line", "Team 1 Score", and "Team 2 Score". Between these 3 columns it is possible to calculate the wins and losses.

  3. #18
    Slurry Pumper is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2016
    Posts
    28
    I hacked around and found something that works without going through the agony of actually learning the Access program. I applied the quote below.



    Quote Originally Posted by govuser1 View Post
    I am trying to get number of employees per hour using their start and stop times.

    I can do this in excel using

    =(COUNTIF($F$2:$F$42,">"&A2)-COUNTIF($E$2:$E$42,">"&A2))

    In a table like
    Time # per hr Start Stop
    4 800
    1 4 800
    200 4 800
    300 4 800
    400 4 600 800
    500 4 600 800
    600 6 800 1600
    700 6 800 1400
    800 13 800 1600
    900 14 800 1600

    ect ect ..

    I need to do this same thing in Access ....I have been searching for anyway and am coming up blank

    Table with Start and End times in the table unlike the excel example above in the table the start and end times are all 4 digits no "zero's" are dropped in the times in case that matters (eg 0000, 0100, 0200, 0300 ect)

    Any help with VBA or any other method that will return number of employees on duty each hour

    Thank you,

    Utilizing the method above, I cam up with this =Count([ATS ])-Count(IIf([ATS]="L",1))-Count(IIf([ATS]="T",1)) in the expression builder. Yeah it works, I would submit that this method can also be used for the OPs purposes.

    I know the purest on this forum will have several different table, queries, and union whatevers normalized and re-arranged.

    Then again the horizontal data in a row thing seems problematic so maybe not.

  4. #19
    Slurry Pumper is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2016
    Posts
    28
    I meant to quote a different post from govuser1. This user was the one who came up with this work around in a different thread.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Count by age range AND gender
    By ncub in forum Reports
    Replies: 10
    Last Post: 10-24-2020, 06:24 AM
  2. Replies: 3
    Last Post: 07-18-2013, 04:21 AM
  3. Replies: 2
    Last Post: 11-25-2010, 11:01 AM
  4. Replies: 3
    Last Post: 08-26-2010, 02:11 PM
  5. Count Dates within Date Range
    By eckert1961 in forum Queries
    Replies: 2
    Last Post: 03-08-2009, 10:58 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