Access database/Results

S

Stu

Have Result pages to display Access database fields. Works
fine, but I wondered how to display fields from more than
one table???
 
K

Kevin Spencer

In a single result set? In multiple result sets? What?

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
 
G

Guest

Sngle, I guess. Page includes a search form. Only
displays 4-5 fields but would like to add another field
from a different table within the same database.
 
K

Kevin Spencer

Use a JOIN query.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
 
S

Stu

That works great with 2-tables using "INNER JOIN".
Now my final question. What type of join is used if there
are 3-tables??
 
K

Kevin Spencer

Hi Stu,

You use the same type of JOIN. The way a JOIN works is that the result of
the JOIN is a result set, which, in a SQL Query, is equivalent to a table.
You can then JOIN that result set to another table. In a sense, you are
using nested JOINs in the same SQL Statement. You may want to use the Access
Query Designer to help you work out the syntax.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
 

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

Help creating a search form in Access XP 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
How do I clear a form? 0
Tracked changes by multiple people modified to one 0
VBA Export to PDF 0
How can the font and size of (all) citation numbers be altered? 1
Slideshow with black border around it 1

Top