Can this be done?

[jakehale]

I have two tables and I'd like to make one queary Utilizing fields from each table. Can this be done? How so? Hopfully it is fairly easy.

I have tried to design a queary and it let me place both tables as references but when i add the fields and then view the queary all the fields are emply when I know i have data in them?????

thanks, hope this clear to understand

Jake

 

[edtab]

It appears to me that you have not done your "join" or have done it incorrectly.

You can use two or more tables as your query source. However, you need to join them using some common fields.

For example, in an order entry system, you would normally have one table to contain basic information about the order --order date, customer name, terms, etc. Then there will be another table to contain the detailed line items of the order. To access the fields from these two tables, you need to join them using a common field. In an order entry system, this is usually the "OrderID". Once joined, all fields from both tables are available to you as a record source for forms, reports, or even other queries.

 

[jakehale]

uh

It appears to me that you have not done your "join" or have done it incorrectly.

You can use two or more tables as your query source. However, you need to join them using some common fields.

For example, in an order entry system, you would normally have one table to contain basic information about the order --order date, customer name, terms, etc. Then there will be another table to contain the detailed line items of the order. To access the fields from these two tables, you need to join them using a common field. In an order entry system, this is usually the "OrderID". Once joined, all fields from both tables are available to you as a record source for forms, reports, or even other queries.

Thanks for the speedy reply

Is "join" a command that I should be seeing, or is it that line that goes between the two table's (when I have the New queary open)?

In a nut shell, I need to have one common (name field) in able to do the "join"?

Thanks, Sorry I seem so "thick" on this........

Jake