Access 2000 how not to limit data by one variable

[Tiggerohio]

Hi all-

I'm self taught with Access and not to sure how to explain what I am trying to do.

I have a database set up to give me directory number to zipcodes and zipcodes to directory numbers (related data to each is included). Now I need to indicate whether or not my client is currently in this directory. When I create a table with the current directories, and include that table with the query, the result is incorrect. For one example there should be 9 results, and now I get 1980 results. I have determined the same 9 results are being duplicated 220 times (The number of directories the client is in).

Any advice is welcomed. Also, if anyone could recommend a good Access book for refrence is helpful.

Thank you
Mike

 

[SkipVought]

Hi,

Sounds like in your Relationship between tables, you should have a ONE to MANY relationship

BUT

you may have a MANY to MANY relationship.

Open the Relationships window and see if your 2 table are there with a line between them that represnets the relationship. Right click the line and change the Option accordingly.

You may not have relationships defined. You may have a relationship implied in your query. You should have a relationship between same data elements something like this...

SELECT A.Name, A.Address, B.Area FROM Names A, Areas B
WHERE A.Name=B.Name AND...

assuming that Name is in both tables

Hope this helps

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Tiggerohio]

Thanks that was it!!!