Jaebyrd240
New member
- Local time
- Today, 08:16
- Joined
- Mar 26, 2015
- Messages
- 6
Hello! I have one large table with about 250 fields and hundreds of records. Each field represents a computer and each record represents an app we have on that computer.
So my table looks like this:
Computer 1.....Computer 2.......Computer 250
Google............Java.................Microsoft
Windows.........Microsoft.............WinZip
Mediaplayer......Google.............Adobe
So as you can see, each computer can have the same apps as other computers. Some computers have apps that other computers do not have.
What I need is just a list of each app we have on all computers.
So my resulting table should have only one field for Apps and only show each app once. Ideally it would look like this:
Apps
Google
Java
Adobe
WinZip
Mediaplayer
I really don't know where to get started... Do a series of queries or macros? Any help is much appreciated! Thanks!
So my table looks like this:
Computer 1.....Computer 2.......Computer 250
Google............Java.................Microsoft
Windows.........Microsoft.............WinZip
Mediaplayer......Google.............Adobe
So as you can see, each computer can have the same apps as other computers. Some computers have apps that other computers do not have.
What I need is just a list of each app we have on all computers.
So my resulting table should have only one field for Apps and only show each app once. Ideally it would look like this:
Apps
Java
Adobe
WinZip
Mediaplayer
I really don't know where to get started... Do a series of queries or macros? Any help is much appreciated! Thanks!