How do I set up formulas in Access?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Krista - 30 Mar 2005 14:53 GMT

I would like to multiply the numbers I put in two of my fields and I can't
figure out how to do this I have a field set up for the answer to go into so
that is not my problem. Sorry if this is confusing I really do not know how
to explain it better.

Reply to this Message

Rick B - 30 Mar 2005 15:14 GMT

As posted alllll the time in here (you should try searching for your answer
before posting a new thread) you DON'T store calculated values. That would
be redundant. You are storing three fields, when you only need two. What
if one of the values changes? How would Access know to change the
calculated figure?

For another example, Let's say you have a name field. You would not wnat to
store every possible format of the name. That would be redundant.

To obtain the calculation, do it in your query, form, or report when you
need it. Add a calculated field in your form, report, or query.

For more details, read any of the hundreds of previous posts on the topic.

Rick B

> I would like to multiply the numbers I put in two of my fields and I can't
> figure out how to do this I have a field set up for the answer to go into so
> that is not my problem. Sorry if this is confusing I really do not know how
> to explain it better.

Reply to this Message

Krista - 30 Mar 2005 18:47 GMT

As much as I value your help I do not appreciate you being so rude. This is
the first time I have had to come on this site and did not have it all
figured out yet. You might have noticed that from me posting in "getting
started". I am just so sorry we are all not a smart as you!

> As posted alllll the time in here (you should try searching for your answer
> before posting a new thread) you DON'T store calculated values. That would
[quoted text clipped - 18 lines]
> how
> > to explain it better.

Reply to this Message

Rick B - 30 Mar 2005 19:01 GMT

Nothing to do with smart. I just use the resources available. I figure
there must be a reason that all these posts are stored out here forever. I
am in the habit of trying to locate answers before asking someone. Just my
basic nature.

Was not being rude, just telling you that the answers are already out there
for you and letting you know what a great resource the newsgroups are if you
search. I have learned almost everything I know about Access from reading
these posts. When I see an interesting one, I make note of it and
incorporate it into my designs.

Rick B

> As much as I value your help I do not appreciate you being so rude. This is
> the first time I have had to come on this site and did not have it all
[quoted text clipped - 23 lines]
> > how
> > > to explain it better.

Reply to this Message

Craig Hornish - 30 Mar 2005 23:34 GMT

Hi,
I have a few question about this since it has been commented on before.

What if the person looking for information uses outlook experess? Do
you advocate that they download all previous posts? or that they must use
the web interface to search?
Even then it is sometimes tough as a newbie to know exactly what and
where to search. - In fact when trying to check on searching the web
interface it was down. (Not really an issue) But as I remember the search
you had to put in dates - really want to search everthing? Then what forum
to search - Yes "Getting Started - has one thread about formulas on 2/8 -
But the main one doesn't ( - from my downloads in outlook express (since web
intereface is down) so are there really hundreds to be found.

These types of questions are always going to be asked by newbies for their
first, second and more times when posting. I think the best way to respond
is to give the answer or link to the FAQ or whatever and suggest those
alternative be looked at.

For anyone who is more experienced I could also offer this unkind way to
any question you have. GO LOOK IN A BOOK - IT ALMOST HAS TO BE THERE. OR
BETTER YET GOOGLE SEARCH IT - IT ALMOST HAS TO BE ANSWERED BEFORE OR
SOLUTION FOUND.

So kind words and suggestions - leave off the sarcastic 100's of times.

jmho

Craig Hornish

> Nothing to do with smart. I just use the resources available. I figure
> there must be a reason that all these posts are stored out here forever.
[quoted text clipped - 50 lines]
>> > how
>> > > to explain it better.

Reply to this Message

Douglas J. Steele - 31 Mar 2005 03:18 GMT

In answer to your question about how to look at previous posts, the usual
recommendation is Google (specifically
http://groups-beta.google.com/advanced_search)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi,
> I have a few question about this since it has been commented on before.
[quoted text clipped - 81 lines]
>>> > how
>>> > > to explain it better.

Reply to this Message

Mark - 30 Mar 2005 16:02 GMT

Are you talking about a table or a form/report? If you mean you have a form
with two textboxes that are tied to fields in the table, and you just want
to display the result of multiplying them together, then in the third
textbox on the form (not bound to any field in the table), for the control
source you can put the formula to do the math:
=[Textbox1] * [Textbox2]
or you can have a query do it and just set the third textbox's control
source to that calculated field.

>I would like to multiply the numbers I put in two of my fields and I can't
> figure out how to do this I have a field set up for the answer to go into
> so
> that is not my problem. Sorry if this is confusing I really do not know
> how
> to explain it better.

Reply to this Message