By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,269 Members | 1,509 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,269 IT Pros & Developers. It's quick & easy.

create new table - no duplicates

P: n/a
access 2000 newbie here -

I need to create a new table (make-table query) selecting from the following
fields in a table:

netname | IP_address | port_number | status | connection

The records can contain duplicate information since the connection and port
number fields will be different.
Netname and IP_address can be duplicated - and I want to create a new table
with no duplicates.

The new table will contain (no duplicates):

netname | IP_address | port_number | status

This will be a list of all hosts on our network.

Thanks in advance.
Rich...
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Make your query Distinct or make it an aggregate query, and select Group By
for all fields.

On Tue, 24 Feb 2004 20:19:52 -0500, "Rich Lussier" <rn*******@charter.net>
wrote:
access 2000 newbie here -

I need to create a new table (make-table query) selecting from the following
fields in a table:

netname | IP_address | port_number | status | connection

The records can contain duplicate information since the connection and port
number fields will be different.
Netname and IP_address can be duplicated - and I want to create a new table
with no duplicates.

The new table will contain (no duplicates):

netname | IP_address | port_number | status

This will be a list of all hosts on our network.

Thanks in advance.
Rich...


Nov 12 '05 #2

P: n/a
that worked - thank you very much

Rich...
"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:nt********************************@4ax.com...
Make your query Distinct or make it an aggregate query, and select Group By for all fields.

On Tue, 24 Feb 2004 20:19:52 -0500, "Rich Lussier" <rn*******@charter.net>
wrote:
access 2000 newbie here -

I need to create a new table (make-table query) selecting from the followingfields in a table:

netname | IP_address | port_number | status | connection

The records can contain duplicate information since the connection and portnumber fields will be different.
Netname and IP_address can be duplicated - and I want to create a new tablewith no duplicates.

The new table will contain (no duplicates):

netname | IP_address | port_number | status

This will be a list of all hosts on our network.

Thanks in advance.
Rich...

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.