Table and Query

[Guest]

Hello,
I have a questin regarding a query I made on my Access 2000 database. I
selected fields from two seperate tables, yet the information contained in
one of the tables (the only one of the two that actually has info in its
records) does not appear in my query. I don't know how to create a
relationship between the two tables that would allow for the information to
appear on the query. I have tried an infinite number of relationships but to
no avail. thank you.

 

[Micah Chaney]

If you have two tables in your Query, and a relationship between them,
you're asking Access to find records where a certain field has matching data
in both Tables. What you want to do is:

From the File Menu | View | Join Properties.
Choose the option that displays all the data in one table (the one with data
in it) and only those that match in the other table.

This should solve your problem, but what are you trying to accomplish with
this query. I'm a bit confused as to what you're trying to do. Maybe I can
help you with a more efficient solution.


microsoft.com> wrote in message
news:[email protected]...

 

[Guest]

As Micah notes; nothing is showing up as it does not find a common field for
a basis of reference. Assuming both tables do indeed have a common column in
order to be cross referenced then use the Relationship Icon from the tool bar
to link the two tables.