can query link with another table??

  • Thread starter Thread starter az
  • Start date Start date
A

az

hola..
i have make a query for a table in my database..but..i need to add
field from another table to that query..can i???can anyone help me???
 
az said:
hola..
i have make a query for a table in my database..but..i need to add
field from another table to that query..can i???can anyone help me???
Click to expand...

A definite maybe. You realize how little information this is, right?
Do the two tables have a field in common? Could you post the SQL?
Can't speak for anyone else here, but my clairvoyant skills just aren't
what they used to be. And shouldn't this be in the queries group?
 
In query design view:

1) add the second table
2) join the two tables as required
3) drag the field from the second table into the query grid.

See Help for more, e.g. the topic "About designing a query"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
VBA - retrieve data on last create named range from previous inserted named range 0
ADODB from Excel - Running a Query 1
Access #Error & Excel Pivot 0
Counting multiple memberships 1
Record insert/delete anomaly 0
Copy Linked Table to Local Table 3
Can't create a report from my query in Access 1

Back
Top