I'm trying to make a field 'value' that is equal to 'cost' *
'quantity'.

I'm new to databases, and this seems like it should be fairly simple.
So far it hasn't been.

Since writing a formula spreadsheet style hasn't worked, I manged to
make a query that will calculate the values I want. Using

Value: components!quantity*components![Cost per Unit]

as the query Field, the query returns the correct data, but how can I
make it store the data in the components.value field?

Thanks for any and all help,
Ryan

Ryan,

You could use your product expression in an update query to do this but it's
usually preferable to just calculate a value like this whenever you need it
instead of storing it.

Mike

"Ryan" <please.reply.to.group (AT) thanks (DOT) com> wrote

Ryan <please.reply.to.group (AT) thanks (DOT) com> wrote

Hell Ryan,

Seems to me you have already achieved what you want. Regarding
Access and the way things work, you don't need to save the value
of the two fields. Just continue doing what you already did.

Create your expression in the query which can be a source for your
form and for any reports that need to be printed. Or, for that
matter, if the data needs to be exported into Excel or whatever.

Again, you don't and shouldn't, in this situation, need to save
your result. Just do what you did.

Regards,

Ray