LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default Analyzing Access Report with Excel

I have a report that I want to analyze with Excel, and it's doing
something that's very interesting, but I'm not sure what it is, and I
don't know what you call it. (Note: for confidentiality purposes, I've
blacked out the names of the advisors).

http://i83.photobucket.com/albums/j3...preadsheet.jpg

Take a look at the far left of that image. See how it has those black
lines with the minuses connected to them? If you click on one of the
minuses, everything in between the minus sign and the top of the black
line closes up, and the minus sign turns into a plus. Anyway, my
question is what do you call those black lines with the minuses next
to them, and how do you create something like this in Excel from
scratch?

Also, I'm not sure that this is displaying correctly. To me, it would
almost make more sense to have the minus sign at the top, and not at
the bottom, starting with the location, since the information cascades
from the location, to advisor, to academic program, like thus.

Location
a) Advisor
i. Academic Program

I hope all of this makes sense. It's hard when you're trying to
describe something and you don't even know what the terminology for it
is.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
When exporting a report from Access to Excel columns misaligned coppinger Excel Worksheet Functions 0 January 18th 07 09:19 PM
MS OfficeLinks (from Access report to Excel) ES Excel Discussion (Misc queries) 2 January 9th 07 07:24 PM
Localize Access Report and Excel Template Peter Excel Discussion (Misc queries) 0 March 29th 06 08:14 AM
Access Form In An Access Report (SubForm) Question Gary Links and Linking in Excel 0 January 27th 06 05:54 AM
Microsoft Access Report into Excel Spreadsheet zeebyrd Excel Discussion (Misc queries) 1 February 27th 05 12:36 AM


All times are GMT +1. The time now is 11:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"