simple query question

[maximos]

Hi everyone
i have 2 question, one queston is based on the other answer.. here is my access layout: I have 2 tables .. the first table (tblMember) has 3 feilds: MemberID, ShareUnits, TotalHolding ... the second table (tblShareValue) has 2 feild: ValueID, ShareValue

What i want to do is, to have the TotalHolding in the first table = ShareUnits * ShareValue (from the other table)

Also ShareValue, is alway a one cell, has no relation with the other Table, it will not grow.

So at the result if the user changes ShareValue, then the TotalHolding will change according..

I hope i'm making sense..

My other question is: Lets say if could put ShareValue in the first table ( so i would have only one table) but if i change one cell, then it will change for the rest, that way when i run my calculation query it will be all in one table..

i hope i made sense explaing.. i really appreciate any help or input, i don't mind changing my table layout as far as i get the result,

Thanks, Max

 

[KenReay]

Hi

You do not need to put ShareValue in first table

Make a query with both tables in it, no relationship join, pull down into the query grid MemberID, ShareUnits, make a Calculated column TotalHoldingValue: [ShareUnits] * [ShareValue]





Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK