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 gkittelson 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. mariew

    SQL to find Avg time between records using date fields

    I know how to use Datediff to find the time between to date fields in a record and how to average the datefield for all records, but is there a way to query a table and find what the average date/time is between the records using only a query? We are using SQL 7.0. Thanks! Julie
  2. mariew

    One PC is truncating decimals in CR7

    Thank you!! Thank you!! That was it. I have looked and looked for the solution. I appreciate your help. Julie
  3. mariew

    One PC is truncating decimals in CR7

    I have one user (NT machine like all the rest) that has the decimals truncated on his reports. The reports are being run from the Crystal ActiveX control in a VB app. Report is based on a MSSQL7 stored procedure. Field is formatted correctly with 2 decimals. Since it works correctly on 30 or...

Part and Inventory Search

Back
Top