Touble Multiplying Fields

[gayle.fisher]

I am new to Access and I am trying to mulitply 2 fields in the same
table. One column is labeled Units and that number varies on each
entry. The other column is labled Rate and that number also varies.
But I have a column labeled Total and I just want the Unit * Rate to
display in the total each time. I just cant figure it out! Help Please.

 

[Guest]

It sounds like your are trying to do this in a table, which would be a
mistake. Tables are not designed to handle or store calculated values. You
need to set up a query based on your table, then do the calculation in the
query. Also, if you are working directly with the table to input data etc.,
you shouldn't be. You should create a form based on the query and use that
for data manipulation.

HTH

 

[Pete D.]

In a update query with those fields dragged into the grid, assume you want
to update the table field total
under update to total under total enter [Rate]*[Units]

 

[Guest]

Never a good idea to keep calculated data in a table. Apart from the
unecessary storage of data, you will need to keep running the update query to
keep data in the table up to date. Best to create a query with the Unit and
Rate fields, along with any other fields in the table, and create the
calculated field there. Then base all reports and forms on this query.

There are probably many other reasons not to store calculated data in a
table, you will find advice against this throught this group.

In a update query with those fields dragged into the grid, assume you want
to update the table field total
under update to total under total enter [Rate]*[Units]

I am new to Access and I am trying to mulitply 2 fields in the same
table. One column is labeled Units and that number varies on each
entry. The other column is labled Rate and that number also varies.
But I have a column labeled Total and I just want the Unit * Rate to
display in the total each time. I just cant figure it out! Help Please.

 

[Pete D.]

Although I know this and usually add that when I tell a "New to Access user"
how to do what they ask. Just telling them don't do it does not answer the
question or teach them how do calculation in a query.

Never a good idea to keep calculated data in a table. Apart from the
unecessary storage of data, you will need to keep running the update query
to
keep data in the table up to date. Best to create a query with the Unit
and
Rate fields, along with any other fields in the table, and create the
calculated field there. Then base all reports and forms on this query.

There are probably many other reasons not to store calculated data in a
table, you will find advice against this throught this group.

In a update query with those fields dragged into the grid, assume you
want
to update the table field total
under update to total under total enter [Rate]*[Units]

I am new to Access and I am trying to mulitply 2 fields in the same
table. One column is labeled Units and that number varies on each
entry. The other column is labled Rate and that number also varies.
But I have a column labeled Total and I just want the Unit * Rate to
display in the total each time. I just cant figure it out! Help Please.

 

[Guest]

Good and valid point, that's how I learned.
My reply was just a continuation from yours, some additional info for the
original post.
Not sure though if I placed my reply in the right place being below yours or
below the original question. Never have been certain aout this one.

On the lighter side, and with hindsight, I really wish someone had told me
not to do many of the things I did when I first started. I was on a mission
to revolutionise relational databases......I am better now

Although I know this and usually add that when I tell a "New to Access user"
how to do what they ask. Just telling them don't do it does not answer the
question or teach them how do calculation in a query.

Never a good idea to keep calculated data in a table. Apart from the
unecessary storage of data, you will need to keep running the update query
to
keep data in the table up to date. Best to create a query with the Unit
and
Rate fields, along with any other fields in the table, and create the
calculated field there. Then base all reports and forms on this query.

There are probably many other reasons not to store calculated data in a
table, you will find advice against this throught this group.

In a update query with those fields dragged into the grid, assume you
want
to update the table field total
under update to total under total enter [Rate]*[Units]

I am new to Access and I am trying to mulitply 2 fields in the same
table. One column is labeled Units and that number varies on each
entry. The other column is labled Rate and that number also varies.
But I have a column labeled Total and I just want the Unit * Rate to
display in the total each time. I just cant figure it out! Help Please.

 

[Pete D.]

Yep, few weeks ago I needed a module I knew I had done something like
before. Found it and started to edit it for my little task. About half way
through I thought to myself, what idiot did it this way. Of course it was
me and I started from scratch cutting it down in size by about half. Know
what you mean about wish I had known back then. Pete D.

Good and valid point, that's how I learned.
My reply was just a continuation from yours, some additional info for the
original post.
Not sure though if I placed my reply in the right place being below yours
or
below the original question. Never have been certain aout this one.

On the lighter side, and with hindsight, I really wish someone had told me
not to do many of the things I did when I first started. I was on a
mission
to revolutionise relational databases......I am better now

Although I know this and usually add that when I tell a "New to Access
user"
how to do what they ask. Just telling them don't do it does not answer
the
question or teach them how do calculation in a query.

Never a good idea to keep calculated data in a table. Apart from the
unecessary storage of data, you will need to keep running the update
query
to
keep data in the table up to date. Best to create a query with the Unit
and
Rate fields, along with any other fields in the table, and create the
calculated field there. Then base all reports and forms on this query.

There are probably many other reasons not to store calculated data in a
table, you will find advice against this throught this group.

:

In a update query with those fields dragged into the grid, assume you
want
to update the table field total
under update to total under total enter [Rate]*[Units]

I am new to Access and I am trying to mulitply 2 fields in the same
table. One column is labeled Units and that number varies on each
entry. The other column is labled Rate and that number also varies.
But I have a column labeled Total and I just want the Unit * Rate to
display in the total each time. I just cant figure it out! Help
Please.