If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to create such a specific report?
Hello!
I need to get data from a table with a query like this: SELECT Sum(R) FROM MyTable WHERE Field1=X and Field2 LIKE Y; X is a field of another table which has a relation '1 to many' with MyTable. Y is not a field but it's a value calculated by VBA script (or, in another case, selected from a list). It's easy to get data with this query when X and Y are known and just single. But I have to create report with these values changing between, f.e., from 1 to 100 for X and from 1 to 20 for Y. In VBA like syntax it's like this: for X=1 to 100 for Y=1 to 20 my query next Y next X How can I create such a report with common tools of MS Access 2003? I tried to do this but didn't manage. WBR Alex. |
Thread Tools | |
Display Modes | |
|
|