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!

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

Recent content by Steevp

  1. Steevp

    Average no of records per day

    Hi John, I would like to get the answer to two questions: For a given year (e.g. 1997) - the average no. of entries per day and the maximum no. of entries in a day For this sample (not the best selection) the results should be 5.75 (23 entries/4 days) and 5 (on both the 20/07/97 and...
  2. Steevp

    Average no of records per day

    Hi John, Still no good (I'm not sure about that sum clause). This is what I am using: SELECT Sheet1.[Date of Stop], max([Rec No]) as max_num, sum([Rec No]) as arg_num1 FROM Sheet1 WHERE (((Right([Date of Stop],2))="97")) GROUP BY Sheet1.[Date of Stop], Sheet1.[Rec No]; A sample of...
  3. Steevp

    Average no of records per day

    Thanks for your help John, However, I am not getting the answer I would expect. The table has records over a number of years. the rec_no field in incremental for the whole table (i.e. 1980 - 24800, but with gaps - presumably where records have been deleted) If I add a Where clause to show only...
  4. Steevp

    Average no of records per day

    Hi, I have a table that have a number of records created each day with a field showing the days date. I need to show the average per day and the maximum number entered in a day. I am using VBScript and trying to pull the info with an SQL statement and it is driving me mad. Your help would be...

Part and Inventory Search

Back
Top