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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Multiple Top 5 Queries In One Query
How can I take a query with the following fields and data: NameParent Name Amount Month(YYYYMM) Amount2 XYZ A 100 200112 1 XYZ B 122 200112 123 XYZ C 34 200112 2 XYZ D 5 200112...- stoynov
- Thread
- Replies: 0
- Forum: Microsoft: Access Modules (VBA Coding)
-
System Resource Exceeded.
I have a report reading off a query that reads off of one total query and two other tables. The query works absolutely fine. However when I run the report to just deliver the query results into it it returns: System Resource Exceeded. And just offers the button OK. How do I get it to work? I...- stoynov
- Thread
- Replies: 0
- Forum: Microsoft: Access Reports
-
Top 5 Query Customization Question
I have a Total Union query that outputs the [Person Name] in column A lets assume at least 15 different people, then [Item Bought] in column B, [Cost] in Column C, and then [MonthendDate] in column D in the format "yyyymm". Assume that each person makes 4-100 purchases per month (could...- stoynov
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Question how to calculate rolling averages in Access
Hi,<br><br>I am sorry that I am not an expert with Access - do you think you could send me an access solution? <br><br>What I am trying to get is from the table "o" with...- stoynov
- Thread
- Replies: 0
- Forum: Microsoft: Access Other topics
