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!
Search results for query: *
- Users: buzzmcduffie
- Order by date
-
rolling 3 months
This query originally comes from: tblAuditData [key]= autonumber [examid] = text [loggedate] = date [NoError] = yes/no tblErrorData [key]= number [errorcode] = text tblError [errorcode] = text [errorcategory] = text [errordescription] = text The first query gives me the total number of...- buzzmcduffie
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
rolling 3 months
I have a query that produces results of the total number of errors each employee has made in 5 categories for each month. I need a rolling 3 month total for each employee for each category in a crosstab query i.e. Rolling Nov total for each category for each emp, rolling Dec total for each...- buzzmcduffie
- Thread
- Replies: 7
- Forum: Microsoft: Access Queries and JET SQL
