Hi there, does anyone know if access is capable of making some more advanced reports -- ones that would not be tabular in the slightest.
I designed a cabling database that holds all the cable records for the University I work for. It's basically done using two tables, an object table (which represents the wall jacks and what not) and a relationship table (which represents the wiring between two objects). The relationship table achieves this by using two columns, "From" and "To", that are related to the unique ID of the objects in the object table.
Anyways, I was wondering if there was anyway possible to create a report to show all the objects linked together with lines, like a master report displaying all of the wiring on my university's campus. I've done it to a very minimal extent already, but it's not flashy in the slightest, as the linear format of Access table limits it.
The data is all here in the system to make this possible, but it's whether or not Access has the ability to create more abstract reports. Does anyone know, or know of any good links? Thanks.
I designed a cabling database that holds all the cable records for the University I work for. It's basically done using two tables, an object table (which represents the wall jacks and what not) and a relationship table (which represents the wiring between two objects). The relationship table achieves this by using two columns, "From" and "To", that are related to the unique ID of the objects in the object table.
Anyways, I was wondering if there was anyway possible to create a report to show all the objects linked together with lines, like a master report displaying all of the wiring on my university's campus. I've done it to a very minimal extent already, but it's not flashy in the slightest, as the linear format of Access table limits it.
The data is all here in the system to make this possible, but it's whether or not Access has the ability to create more abstract reports. Does anyone know, or know of any good links? Thanks.
