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