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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.