totaling columns

[Guest]

First of I would like to say I'm an excel kind of guy so if this post else
where I'm sorry for the repeat.And I'm new to access.

I have a query "qry_test" that has six fields i would like to add one more
but in this field I would like to total up the cost of damaged goods.

Column #1= Company Code#
Column #2= Product Description
Column #3= Quantity
Column #4= Date
Column #5= Case Price
Column #6= Case Quantity

I have two tables tbl_Products and tbl_Damaged

Company Code,Product Description, Case Quantity and Price come from
tbl_Products

the balance from tbl_Damaged

in column #7 I would like to find the total cost of damaged goods

Quantity (Case Price/Case Quantity)

like I said I'm an Excel kind of guy and I could figure it out in Excel but
being new to access I'm stumped???

In advance thank you

 

[Guest]

Hi

Do you have a field (tick box / Yes - No / etc) in your tbl_Products that
shows if a product is damaged. If you do it is quite simple to show the
total for damaged article.

If not. How do you record if a product is damaged (field name and table
would be helpful)

 

[Guest]

no,the quantity of Damaged goods are listed in a seperate table
tbl_DamagedGoods

 

[Guest]

hi Wayne, thanks for your quick reply
sorry (brain fart) I guess alittle more info would be nice.

tbl_DamagedGoods have 5 fields Id,Company Code#, Description, Quantity,Date
that's it

tbl_Products has 9 fields Id,Category,taxed,Company
Code,Location,Description, Case Quantity,Case Price,Vendor

 

[Guest]

Column #7=
DamagedGoods: Sum([tbl_DamagedGoods]!

*[tbl_Products]![ Price])

 

[Guest]

Ooops - thats wrong.
Hang on I'll re do it

--
Wayne
Manchester, England.

Column #7=
DamagedGoods: Sum([tbl_DamagedGoods]!

*[tbl_Products]![ Price])


--
Wayne
Manchester, England.



[QUOTE="hellZg8"]
hi Wayne, thanks for your quick reply
sorry (brain fart) I guess alittle more info would be nice.

tbl_DamagedGoods have 5 fields Id,Company Code#, Description, Quantity,Date
that's it

tbl_Products has 9 fields Id,Category,taxed,Company
Code,Location,Description, Case Quantity,Case Price,Vendor
[/QUOTE][/QUOTE]

 

[Guest]

I just made your tables to check this (I have a dizzy head on today). All
you need to do is ensure that both tables are shown is the design grid and
then drag the

 from the tbl_DamagedGoods into culumn 7 you will insert
this amount into the query.  You can then simply click the total icon (at the
top of the screen) and use the sum function on the [Price].

Sorry about the last answer (was answering 2 people questions at the same
time ) the other is my sister - by e mail so she "must" get the right answer.

--
Wayne
Manchester, England.



[QUOTE="Wayne-I-M"]
Ooops - thats wrong.
Hang on I'll re do it

--
Wayne
Manchester, England.



[QUOTE="Wayne-I-M"]
Column #7=
DamagedGoods: Sum([tbl_DamagedGoods]![Code]*[tbl_Products]![ Price])


--
Wayne
Manchester, England.



[QUOTE="hellZg8"]
hi Wayne, thanks for your quick reply
sorry (brain fart) I guess alittle more info would be nice.

tbl_DamagedGoods have 5 fields Id,Company Code#, Description, Quantity,Date
that's it

tbl_Products has 9 fields Id,Category,taxed,Company
Code,Location,Description, Case Quantity,Case Price,Vendor
[/QUOTE][/QUOTE][/QUOTE]