Excel to Access Link

T

tollgoat

After I have linked an excel spreadsheet to an access table I wish to be able
to hide some of the rows of information that I do not want displayed when I
create a report from the linked table.

I'm getting a window message that tells me the action cannot be performed on
a linked table.

Does anyone know another way?

thx
 
J

Joan Wild

You can create a query based on this table, and specify a criteria that
limits the output to just the rows you want; base your report on this query.
 
T

tollgoat

Thank You

Joan Wild said:
You can create a query based on this table, and specify a criteria that
limits the output to just the rows you want; base your report on this query.
Click to expand...
 
T

tollgoat

Joan,

Maybe I'm still doing something wrong but the result although better is
still not quite what I'm looking for.

The goal is that rows with "0" values do not display at all. The information
I want displayed should all fit on one page yet there might be 6 pages to my
report.
1 page of desired results and 5 pages of blanks. The "0" values don't
display but I still have 5 excess pages on the report. I know I can print
just the pages I want but if possible like to see just the one page on the
report.

????????

thx
tg
 
J

Joan Wild

Do you mean you have five completely blank pages? If so, then check the
margins of your report in page setup, and in design view make sure that you
report isn't wider than the page size (i.e. if you have a 1" left and right
margin, then the report can't be wider than 6.5" portrait, 9" landscape).
 
Top