ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Flowing Row Display When Query from Access (https://www.excelbanter.com/excel-programming/383430-flowing-row-display-when-query-access.html)

tkirchoff15

Flowing Row Display When Query from Access
 
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....

Tom Ogilvy

Flowing Row Display When Query from Access
 
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....





All times are GMT +1. The time now is 05:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com