Prev: how to remove html tags from a field in MSACCESS.
Next: Can't enter data in query datasheet
From: legacy on 22 Apr 2010 13:50
Hi,
I created a query to add values from two different tables. However, some of
the results are been multiplied by two and some of them by three. Is there
anything I need to do on the query itself to solve this calculation issue?

Thanks
From: Bob Barrows on 22 Apr 2010 13:58
legacy wrote:
> Hi,
> I created a query to add values from two different tables. However,
> some of the results are been multiplied by two and some of them by
> three. Is there anything I need to do on the query itself to solve
> this calculation issue?
>

Probably
Show us the sql statement (switch your query to SQL View) and we might
be able to offer a solution.
--
HTH,
Bob Barrows


From: KARL DEWEY on 22 Apr 2010 14:09
You have a Cartesian effect due to not joining the two tables. It multiplies
each record in table1 by the number of records in table2.
If you join the tables you won't get the effect.
If you do not know how to join the table post the structure indicating table
and field names with datatype. Post sample data also. What field is common?

--
Build a little, test a little.


"legacy" wrote:

> Hi,
> I created a query to add values from two different tables. However, some of
> the results are been multiplied by two and some of them by three. Is there
> anything I need to do on the query itself to solve this calculation issue?
>
> Thanks
 | 
Pages: 1
Prev: how to remove html tags from a field in MSACCESS.
Next: Can't enter data in query datasheet