Report accessing multiple rows from query
Posted on 2007-07-24
In Access I have a query that sorts out my customers by the top 5 spenders. When I run the query sometimes there may only be 1,2 3 or 4 spenders.
I have a report that organizes these spenders into 5 columns. Showing their name, delivery info, total expenditures etc. I would like my report to recognize each spender and put them and their information in the report from 1 to 5. if there is less than 5 spenders, the report leaves the last colum(s) blank.
In other words, the report will enter into column1(report) all data from row 1 (query). Same with colum2(Report) row2 (query) etc.