Hi,

Is there anyone who can help me making a simple SUM

DB1
----
BarCode
Count

DB2
----
BarCode
Text
Price
....


I want to get all the records (including dubblets) in DB1 and then get
the Count to summerize a total count. Then I want to calc the total
Count with Price (without dubblets).

When I try some records are calculated correctly others not.

Query Test1
DB1
-----
Barcode V
Count calc sum all as Total numer

DB2
-----
Barcode
Text V
Price V

<Hotmail.com> wrote:

This is easy if BarCode is unique in DB2:

Untested, but:

SELECT a.BarCode, SUM(a."Count") AS TotalCount, b.Price
FROM DB1 a INNER JOIN DB2 b on (a.Barcode = b.Barcode)
GROUP BY BarCode, Price

or

DB1 | BarCode | Count |
DB2 | Barcode | Text | Price |
If this isn't what you're looking for, let us know. It's best if you post
some sample data (as text, not attachments) and what the corresponding
answer table would be.

--
Larry DiGiovanni

Thankz. I'll try it out

On Tue, 20 Mar 2007 10:37:09 -0400, "Larry DiGiovanni"
<nospam (AT) nospam (DOT) com> wrote:

Hi again,
I have tried, but get an error regarding db1 in line 2.

I'm now tring with a query instead. But what does "_a" mean ?

TIA

MJ

On Tue, 20 Mar 2007 10:37:09 -0400, "Larry DiGiovanni"
<nospam (AT) nospam (DOT) com> wrote:

<question (AT) Hotmail (DOT) com> wrote:

OK I will now read your mind to figure out the error you saw.

The underscore indicates an example element, which is used to join tables in
a query. In the query image under those two fields, just press F5 a and
move out of the field. The a will actually show up in red to show that they
are examples.

--
Larry DiGiovanni

:-) It just says that there is an error in line 2 (DB1).

I'll try with the F5

Thanks again.

MJ

On Tue, 20 Mar 2007 12:28:50 -0400, "Larry DiGiovanni"
<nospam (AT) nospam (DOT) com> wrote: