I need a way to display rows from an access query. The rows need to float
in the spreadsheet when queried and the row count changes. Example: You may
have 3 rows in the first query and then have 6 rows in the next. The rows
need to expand when this happens not affecting the header rows below the
query rows. Also, the rows need to compress when there re fewer rows.
Thanks for your help....

right click on the query area in the worksheet and select options. See what
works for you.

--
Regards,
Tom Ogilvy

"tkirchoff15" wrote in message
...
I need a way to display rows from an access query. The rows need to float
in the spreadsheet when queried and the row count changes. Example: You
may
have 3 rows in the first query and then have 6 rows in the next. The rows
need to expand when this happens not affecting the header rows below the
query rows. Also, the rows need to compress when there re fewer rows.
Thanks for your help....