Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Minneapolis, MN, Minnesota
    Posts
    162
    Thanks
    1
    Thanked 0 Times in 0 Posts

    FORM FORMATTING (Access 2000)

    I AM IN NEED OF DESERATE HELP!

    I have a subform that is linked to the mainform by Project ID. I want the subform to display 3 fields: 1) First Name; 2) Last Name; and 3) Hours.I want the subform to show me each different employee (first and last name) who works on the project ONLY ONCE with a field next it that displays the total hours worked on THAT PARTICULAR project for that employee.

    CAN ANYONE HELP ME SOON!
    Easy Access

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: FORM FORMATTING (Access 2000)

    Make a new query, and make it a Totals query. Group by Project ID and employee ID, or employee name if necessary, and choose to Sum the hours worked field. Make that new query be the record source for your subform -- walla! Good luck!
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: FORM FORMATTING (Access 2000)

    If you follow Shane's suggestion, keep in mind that you will be able to display the information but it will not be editable.
    Charlotte

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: FORM FORMATTING (Access 2000)

    There is another issue here that you might bump into.

    If the number of hours worked on any project exceeds 24, then you need to consider the format of the answers.
    Date/time data is stored with the time component as the decimal part on the end. When the hours exceed 24, the hours roll over into the whole number bit, and Access does not want to display them as time. I usually multiple the time total by 24 and format in a fixed format display say 26.5 meaning 26 hours 30 mins.

    I would be interested to know of other ways of dealing with this.
    Regards
    John



  5. #5
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Minneapolis, MN, Minnesota
    Posts
    162
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: FORM FORMATTING (Access 2000)

    Hey Shane!
    First let me express my utmost thanks. I am eternally grateful. I was pulling my hair out trying to figure that one out.
    Your suggestion worked great!
    Easy Access

  6. #6
    2 Star Lounger
    Join Date
    Aug 2002
    Location
    Minneapolis, MN, Minnesota
    Posts
    162
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: FORM FORMATTING (Access 2000)

    Hey John,
    Thanks for the advice, but the field I am using is not a Date/Time field. I will keep your advice in mind for future projects/and or problems I encounter.
    Easy Access

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •