M
Memento
Hello guys,
I'm think i just might be trying to do something here that seems to be
difficult, or poorly documented. I am trying to build a query based on one
table (hardware). The table hardware contains fields like manufacturer,
model, type, ipaddress, mapping, location, etc...
I'm using a listbox, and want to be able to view (in one column),
manufacturer, model & type (SELECT hardware.manufacturer & " " &
hardware.model & " - " & hardware.type FROM Hardware)
But i also want the IP-adresses, mapping and location listed in the same
listbox (one column)...
So i would have (for example):
- Intel Core 2 Duo E6600 - CPU : example hardware
- Hewlett Packard LaserJet 2015n - Laserprinter : example hardware
- HPLASER2015 : example mapping
- 188.88.88.90 : example IP
- North Carolina : example location
Is this even possible?
With regards,
Memento
I'm think i just might be trying to do something here that seems to be
difficult, or poorly documented. I am trying to build a query based on one
table (hardware). The table hardware contains fields like manufacturer,
model, type, ipaddress, mapping, location, etc...
I'm using a listbox, and want to be able to view (in one column),
manufacturer, model & type (SELECT hardware.manufacturer & " " &
hardware.model & " - " & hardware.type FROM Hardware)
But i also want the IP-adresses, mapping and location listed in the same
listbox (one column)...
So i would have (for example):
- Intel Core 2 Duo E6600 - CPU : example hardware
- Hewlett Packard LaserJet 2015n - Laserprinter : example hardware
- HPLASER2015 : example mapping
- 188.88.88.90 : example IP
- North Carolina : example location
Is this even possible?
With regards,
Memento