Results 1 to 3 of 3
  1. #1
    macattack03 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Apr 2011
    Posts
    15

    making a query

    I'm very new to access and taking a class currently to learn more however i'm stuck with the part with making a query and then adding extra stuff to it ill attach the file and the instructions that i have maybe someone can help or explain what its suppose to look like

    Instructions

    1. Use the Simple Query Wizard to create a query that will display the fields from the Employees, Employee Dates and Salaries, and Employee Benefits tables as follows:
    Employees Employee Dates and Salaries Employee Benefits
    Emp No Hire Date Life Insurance


    FirstName Annual Salary
    LastName
    2. Accept the default Detail query and then key Salaries and Life Insurance as the title for the query. View the query results datasheet and then close the query.
    3. Open the Salaries and Life Insurance query in Design view. Sort the query results by the LastName field in ascending order.
    4. Add a criteria statement in the Annual Salary field that will extract the records of employees who earn more than $44,000.
    5. Create a calculated field in the column after Life Insurance that will divide the Annual Salary column by 12 to display the monthly salary. Label the new column Monthly Salary.
    6. Format the Monthly Salary column to display the calculated values in Currency format.

    I think i got the query thing made but the part im not understanding are steps 4-5

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I deleted your other thread. Please no not post the same issue in more than one thread.

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Can I assume (because of your 3rd thread) you now know how to do item 4 in the list?

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

Similar Threads

  1. Making A Query Criteria Urgent Help
    By jarrydred in forum Queries
    Replies: 2
    Last Post: 06-03-2010, 12:59 AM
  2. Replies: 4
    Last Post: 03-04-2010, 06:26 AM
  3. Replies: 7
    Last Post: 01-07-2010, 12:20 PM
  4. making into update query
    By tom4038 in forum Queries
    Replies: 1
    Last Post: 09-23-2009, 11:19 AM
  5. Making a new field in a query
    By mslieder in forum Queries
    Replies: 3
    Last Post: 05-14-2008, 11:44 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