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 IamaSherpa 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: *

  1. DonHind

    Loop through table

    Thanks, I'll try this out.
  2. DonHind

    Loop through table

    I have a table with two fields, one is date/time and the other is on/off. Our machine logs a record every minute. The shift is 12 hrs, so the table has 720 records. The purpose is to monitor the machine every minute to know if it is in operation or shut down. I want to loop through the table...
  3. DonHind

    How summarize production by date/time

    We make rolls of cloth. My table has fields [StockCode], [RollNumber], [RollWeight], [RollDateTime]. We have production runs that last from 6 hrs to 3 days with rolls coming off the machine every 15 minutes or so. I want write a query to be able to calculate the number of rolls, total weight...
  4. DonHind

    Ignore zeros when averaging

    I have a report that summarizes lab data. Occasionally they do not run all the tests and a field will have a zero in it. When I average on the report I would like to ignore the zeros. I tried to do IIF function in the summation field like Excel does on columns to ignor zeros, but the report...

Part and Inventory Search

Back
Top