Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ramoneguru
Yak Posting Veteran
69 Posts |
 Posted - 2006-07-17 : 15:15:05
|
| I have a query that will get all the data from a one to many relationship (Num -- Feature). It gives me something like this:Num__Feature123 hot123 cold123 warm123 warm warm123 cold cold123 warm cold123 hot cold256 burn256 first degree256 second degree256 third degree...Is there a way to have Access just display the 'Num' attribute and have that "+" show up so the user could expand the 'Feature' attribute if they wanted to? So it looks like this:Num__Feature123 + 256 +So, when you click the + it will expand and show all the Features. Is it possible?--Nick |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-07-17 : 17:52:48
|
| It depends on how you want to display it.If you open a table for viewing, there is a plus sign in the first column by default (IIRC Access 2003+). You can use this to link to a child table. But this is only of use if you are in table view.You can also create a report in Access that shows the data in a heirarchical structure like you're after. If you do this correctly, you can export the report as a spreadsheet that preserves the drill-down functionality. HTH,Tim |
 |
|
|
|
|
|
Stop repeating data from showing