By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,506 Members | 2,311 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,506 IT Pros & Developers. It's quick & easy.

3 tables into one Queries?

P: n/a
I have 3 different tables that I want Queries to sum up, but I do not get
all the information into my Queriy-file.
The 1st table have 9 different products.
The 2nd table have 3 of those 9 products.
The 3rd table have 3 of those 9 products, one of those 3 products is similar
to one of those products in table 2.

My problem is that I do not get all the information into the Queries. I just
get 1 product, which is represented in all tables.

How do I get all information from those 3 tables into the one Queries??

-kenneth
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Wed, 28 Apr 2004 15:40:58 +0200, "Kenneth" <sn*******@hotmail.com>
wrote:

Use outer joins rather than inner joins. Right-click the line between
the tables in the Query design grid, and select option 2 or 3.

-Tom.

I have 3 different tables that I want Queries to sum up, but I do not get
all the information into my Queriy-file.
The 1st table have 9 different products.
The 2nd table have 3 of those 9 products.
The 3rd table have 3 of those 9 products, one of those 3 products is similar
to one of those products in table 2.

My problem is that I do not get all the information into the Queries. I just
get 1 product, which is represented in all tables.

How do I get all information from those 3 tables into the one Queries??

-kenneth


Nov 12 '05 #2

P: n/a
Kenneth,

It's not clear what you have!

When you base a query on multiple tables, the tables have to be joined in the
query window. The query then only returns records where there is a value in the
joined fields in both tables. What you may be seeing is that values exist in the
join field of all the records in one table but in some of the records in the
other table, there are no values in the joined field. Consequently, the query
does not return all the records in the first table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"Kenneth" <sn*******@hotmail.com> wrote in message
news:c6**********@dolly.uninett.no...
I have 3 different tables that I want Queries to sum up, but I do not get
all the information into my Queriy-file.
The 1st table have 9 different products.
The 2nd table have 3 of those 9 products.
The 3rd table have 3 of those 9 products, one of those 3 products is similar
to one of those products in table 2.

My problem is that I do not get all the information into the Queries. I just
get 1 product, which is represented in all tables.

How do I get all information from those 3 tables into the one Queries??

-kenneth

Nov 12 '05 #3

P: n/a
Thank you so far, then next problem pops up.
"The query displays empty cells where there is no matching record from
another table", but I want to sum all values in a column in the Query, and
as long as there is no matching record, I can't sum. What can I do to solve
that?

-kenneth
"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:sl********************************@4ax.com...
On Wed, 28 Apr 2004 15:40:58 +0200, "Kenneth" <sn*******@hotmail.com>
wrote:

Use outer joins rather than inner joins. Right-click the line between
the tables in the Query design grid, and select option 2 or 3.

-Tom.

I have 3 different tables that I want Queries to sum up, but I do not get
all the information into my Queriy-file.
The 1st table have 9 different products.
The 2nd table have 3 of those 9 products.
The 3rd table have 3 of those 9 products, one of those 3 products is similarto one of those products in table 2.

My problem is that I do not get all the information into the Queries. I justget 1 product, which is represented in all tables.

How do I get all information from those 3 tables into the one Queries??

-kenneth

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.