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 Chriss Miller 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 overdog1979
-
Help with avg() function in Access
Sorry, my first post probably wan't that clear I haven't actually done these in access, this is just to show what i want. For each unique panel ane and dataype, I want an average of all of DaysLateNorm. For example, Panel code A dataype MDS, the values for daylate norm are, 0, 0, 0, 3. I want...- overdog1979
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Help with avg() function in Access
Hi, I have the following query SELECT tblSalesStatistics.strDbName AS [Database], tblSalesStatistics.strPanelCode AS PanelCode, tblDataType.strTypeCode AS Type, [tblSalesStatistics.strMFYear] & "/" & [tblSalesStatistics.strMFMonth] AS TimePeriod...- overdog1979
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
