Results 1 to 4 of 4
  1. #1
    Jfort866 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    2

    Creating Uniform allowance report

    I am completely new to access,

    As part of my job I was asked to create a report that shows whether a person is entitled to their uniform allowance. The time period needed to be eligible is 6 months. I have imported a sharepoint line-up list that shows every person and every single time and day they worked. I created a Query that provides me with the first start date and time and the last end date and time for every person (so that there is only one row per person). I now need to make it so that it confirms whether or not the individuals are eligible for the allowance based on whether they have worked 6 months or not. How do I go about doing this?

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Are you just trying to determine if each person's 'first start date' is more than 6 months ago?
    How do you calculate the 6 months - is it 'to - the - day'?
    You can research the 'DateSerial()' function to use in your query.
    For instance, I use this in the Criteria row of a Date field in one of my queries:
    Code:
    Between DateSerial(Year(Date()),Month(Date())-13,1) And DateSerial(Year(Date()),Month(Date())-12,0)
    It gives me data for the entire month that is 13 months ago [Eg: in June this year -> I get May last year's data].

    Hope this helps!!

  3. #3
    Jfort866 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    2
    I have to make a query that finds if an employee has been working in the department the last 6 months. the report needs to come out twice a year (once in July and once at the end of December). The query should then take these months and multiply it by the amount of money that is given monthly for uniform allowance.

  4. #4
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Is every employee given the same monthly uniform allowance?
    If so, they'll all get the same amount - right [6 * UniformAllowance]?
    In the query you have already created, under the First_StartDate_Time field -> in the Criteria row -> put this:
    Code:
    > DateSerial(Year(Date()),Month(Date())-7,1)
    Then, you can just add a field to the query - like this:
    Allowance_Due: "$123.45"


    If each Employee has a separate uniform allowance, where is that value stored for each employee? Is it in a field in your Table?
    Are you already picking that value up in the query that you already created?

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

Similar Threads

  1. Creating a dashboard report
    By vicky464 in forum Reports
    Replies: 2
    Last Post: 11-04-2011, 09:20 AM
  2. I need help in creating a database report.
    By fastorm in forum Queries
    Replies: 1
    Last Post: 10-27-2010, 09:54 PM
  3. creating report
    By Balen in forum Reports
    Replies: 1
    Last Post: 08-12-2010, 06:45 PM
  4. Creating a report
    By nebuk89 in forum Reports
    Replies: 3
    Last Post: 07-01-2010, 06:49 AM
  5. Help with creating a Report..
    By TylerZ07 in forum Reports
    Replies: 2
    Last Post: 12-11-2009, 07:51 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