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.