Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / May 2008

Tip: Looking for answers? Try searching our database.

Add towns

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve - 11 May 2008 10:28 GMT
I have a table which has all towns and States and postcodes (zipcodes)
for Australia.  Many duplications of town name occur as there can be
more than one town in different states or even same town name in one
state but different postcode.

No problem , the data is already there.

However I would like to be able to add non Australian Names but ensure
there is no duplication on adding.  I cant use Town name as Indexed ,
no duplicates (because of duplication mentioned above) and need a
method to have a combination of State, Town and Postcode or Twon and
Postcode not allow for duplicates.
Any help appreciated
Steve
Bob Quintal - 11 May 2008 12:36 GMT
Steve <stevecox4444@gmail.com> wrote in
news:0b50cdbb-a13d-4f80-a120-4aecf1416668
@n1g2000prb.googlegroups.com

> I have a table which has all towns and States and postcodes
> (zipcodes) for Australia.  Many duplications of town name occur as
[quoted text clipped - 10 lines]
> Any help appreciated
> Steve

so open the table in design mode, click on the record selector for
town, Control Click on the record selector for state, control-click
on the record selector for postcode, then click on the key icon in
the toolbar. save your changes.

That will either create a new primary key with the three fields, or
tell you that there are duplicates.

It's that simple.

Now click on the indexes icon in the toolbar and see how Access has
entered the data, so you can additional compound indexes using the
indexes dialog.

Signature

Bob Quintal

PA is y I've altered my email address.
** Posted from http://www.teranews.com **

Steve - 12 May 2008 08:26 GMT
> Steve <stevecox4...@gmail.com> wrote in
> news:0b50cdbb-a13d-4f80-a120-4aecf1416668
[quoted text clipped - 34 lines]
> PA is y I've altered my email address.
> ** Posted fromhttp://www.teranews.com**

Thanks for the assist- much appreciated

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.