MS Access and Internet - Access Query with Viso

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Access Query with Viso

savvy95

2005-04-06, 8:05 pm

Scenario --
I have Access Db with computername, IP address, NICName, SubnetMask,
Gateway, DNS, Wins and Domain. I may have over engineered the Db, but I have
separate records for the same computer, but different DNS, WINS and IP (as
some NICs have up to 10 IPs).

Now, I have 2-fold question. 1. How can I get visio and Access to give a
report per computer, listing all IPs. In other words the boss wants to see
one entry and a list of the computers IPs.

If I use visio and link computers to Db, I only one IP is listed when queried.

How can I fix this?

All help is appreciated.

Sponsored Links