I have an MS query that import certain records based on parameters entered by
the user. No problem here.
I created the report using the wizard, I selected the range based on the
parameters that I entered. The problem is that I do not know the possible
number of records, therefore the report may not include all of them (the
number of records varies depending on the parameters, it could 5 or it could
be 500 records). I removed the check mark for the [blank] box in the drop
down box in the reoprt. The problem is when the number of records is greater
thatn the initial numbers or rows that I selected when the report was created.

Question: Is there a way for Excel to select all the records given by the MS
query everytime the report is updated?

Thanx