|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
December 8th, 2004, 09:48 AM
|
|||
|
|||
|
Querying queries
I've just pulled together a DB, with serveral tables
eg MAC_import_192_168_0_0 MAC_import_192_168_1_0 MAC_import_192_168_2_0 MAC_import_192_168_3_0 each contain 2 string fields 1 ip address in the format "192.168.0.0", "192.168.1.0". The second field contains the mac address for the relating IP. I have several queries, one for each table which pop's up a box requesting the IP address of a machine before displaying IP and mac. I would like however to do this with one query rather than having to select the appropriate one. Any ideas, i'm not really that good wif DB's as its been 8 years since i did anything with them. Thanks much
|
|
#2
December 8th, 2004, 05:20 PM
|
|||
|
|||
|
bikky,
Is not possible to create just one table? It sounds like you keep the same data types in all the tables with similar information in each one of them. Or are the tables too unique to do that. lwells
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Querying queries |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
