By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,372 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

I could use some help with a query using mulitplication

P: n/a
Here is what I have. I have a field that lists a product cost and another
field that lists how many times that particular product has been purchased
(so I would have a record that says I bought 25 of these items at $5.00
each). I need to create either another field or a query that multiplies the
two together. I have many such records like this and want to do this for
each record.

I am totally new to access and am just learning so any help would be very
useful. Can anyone point me in the right direction.

Thank you in advance,

Scott
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a

"Scott Cameron" <th***********************@anywhere.com> wrote in message
news:ZFSEe.27912$%K2.5663@pd7tw1no...
Here is what I have. I have a field that lists a product cost and another
field that lists how many times that particular product has been purchased
(so I would have a record that says I bought 25 of these items at $5.00
each). I need to create either another field or a query that multiplies
the two together. I have many such records like this and want to do this
for each record.

I am totally new to access and am just learning so any help would be very
useful. Can anyone point me in the right direction.

Thank you in advance,

Scott


Create a third field in your query to hold the result of the calculation,
thus:

MyResult: [ProductCost]*[Items]

Nov 13 '05 #2

P: n/a
Thanks. That solved that problem. Now I need to create a total of all these
new values (which I create using a new "sum" query referencing the subtotals
query I just made) but when I go to create a report using the two queries I
am told that the one query is referencing the other so it can't be included
in the report. I am so close it hurts! How do I include the sum total in
the original query?
--
Scott

"m22we7" <no****@nospam.net> wrote in message
news:1122239119.649b3f42b055034faa895d32f1f98601@t eranews...

"Scott Cameron" <th***********************@anywhere.com> wrote in message
news:ZFSEe.27912$%K2.5663@pd7tw1no...
Here is what I have. I have a field that lists a product cost and
another field that lists how many times that particular product has been
purchased (so I would have a record that says I bought 25 of these items
at $5.00 each). I need to create either another field or a query that
multiplies the two together. I have many such records like this and want
to do this for each record.

I am totally new to access and am just learning so any help would be very
useful. Can anyone point me in the right direction.

Thank you in advance,

Scott


Create a third field in your query to hold the result of the calculation,
thus:

MyResult: [ProductCost]*[Items]

Nov 13 '05 #3

P: n/a
You haven't given enough information for me to understand why you need to
use a totals query... if you have a calculated field in your query, you
should be able to use the Sum function in the Group or Report footer to show
its sum.

If that is not, for some reason, acceptable, post back with clarification.

Larry Linson
Microsoft Access MVP

"Scott Cameron" <th***********************@anywhere.com> wrote in message
news:tfUEe.28432$s54.15432@pd7tw2no...
Thanks. That solved that problem. Now I need to create a total of all
these new values (which I create using a new "sum" query referencing the
subtotals query I just made) but when I go to create a report using the
two queries I am told that the one query is referencing the other so it
can't be included in the report. I am so close it hurts! How do I
include the sum total in the original query?
--
Scott

"m22we7" <no****@nospam.net> wrote in message
news:1122239119.649b3f42b055034faa895d32f1f98601@t eranews...

"Scott Cameron" <th***********************@anywhere.com> wrote in message
news:ZFSEe.27912$%K2.5663@pd7tw1no...
Here is what I have. I have a field that lists a product cost and
another field that lists how many times that particular product has been
purchased (so I would have a record that says I bought 25 of these items
at $5.00 each). I need to create either another field or a query that
multiplies the two together. I have many such records like this and
want to do this for each record.

I am totally new to access and am just learning so any help would be
very useful. Can anyone point me in the right direction.

Thank you in advance,

Scott


Create a third field in your query to hold the result of the calculation,
thus:

MyResult: [ProductCost]*[Items]


Nov 13 '05 #4

P: n/a
Actually I think I just found what I was looking for. I just found and
used, very successfully, the summary options in the report wizard. Thanks.

--
Scott

"Larry Linson" <bo*****@localhost.not> wrote in message
news:EyWEe.3012$sc3.2930@trnddc07...
You haven't given enough information for me to understand why you need to
use a totals query... if you have a calculated field in your query, you
should be able to use the Sum function in the Group or Report footer to
show its sum.

If that is not, for some reason, acceptable, post back with clarification.

Larry Linson
Microsoft Access MVP

"Scott Cameron" <th***********************@anywhere.com> wrote in message
news:tfUEe.28432$s54.15432@pd7tw2no...
Thanks. That solved that problem. Now I need to create a total of all
these new values (which I create using a new "sum" query referencing the
subtotals query I just made) but when I go to create a report using the
two queries I am told that the one query is referencing the other so it
can't be included in the report. I am so close it hurts! How do I
include the sum total in the original query?
--
Scott

"m22we7" <no****@nospam.net> wrote in message
news:1122239119.649b3f42b055034faa895d32f1f98601@t eranews...

"Scott Cameron" <th***********************@anywhere.com> wrote in
message news:ZFSEe.27912$%K2.5663@pd7tw1no...
Here is what I have. I have a field that lists a product cost and
another field that lists how many times that particular product has
been purchased (so I would have a record that says I bought 25 of these
items at $5.00 each). I need to create either another field or a query
that multiplies the two together. I have many such records like this
and want to do this for each record.

I am totally new to access and am just learning so any help would be
very useful. Can anyone point me in the right direction.

Thank you in advance,

Scott

Create a third field in your query to hold the result of the
calculation, thus:

MyResult: [ProductCost]*[Items]



Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.