Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Dyer
  • Order by date
  1. Dyer

    Group total Based on last 80 Records ?

    Looks Great ! Thanks,
  2. Dyer

    Group total Based on last 80 Records ?

    All, I tried the TOP 80 on a date field today and as you said I got different numbers of records due to ties on the last day etc. I used the unique ID field to sort the entire table and ran an additonal query to pick out the most recent 80 records for a team. The unique ID worked very well...
  3. Dyer

    Group total Based on last 80 Records ?

    Thank you very much for your help ! I would like to select the most recent 80 records by date and time for each team number in my table. I was not specific enough in my original post. I will run the query on a daily basis to determine which teams have over X amount of defects in the last...
  4. Dyer

    Group total Based on last 80 Records ?

    I have an Access table based on team defect counts. I need to sum the number of defects by team for the last or most recent 80 records. It would be acceptable to sum every 80 records starting at the most recent 80 records. Can anyone help ? Thank You,

Part and Inventory Search

Back
Top