How can I do Calculations in a Query?

  • Thread starter LisaJohn via AccessMonster.com
  • Start date
L

LisaJohn via AccessMonster.com

Hi

I've already created a query based on a table and I am at a point where I
would like to add two fields together and have the data from that equation in
another field on the same table. I have already completed the calculation but
the two numbers that I added together are sitting side by side in the new
field.

How can I get the numbers to finally compute within this new field and to not
sit side by side?

It currently looks like this:

Field 1 Field 2 Field3
200 200 200 200

Any help would be great!

I am a newbie. Thanks in advance!
 
R

RonaldoOneNil

Type this into the top row of your 3rd column in your query

Field3: [Field1]+[Field2]
 
D

Duane Hookom

You have two similar but more complete replies in the Database design news
group.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding two fields to Equal one Field 6
linked table using SQL Query 8
Delete all data after a symbol in a field 0
Finding the right style field in VBA 0
dynamic calculated field in query 3
How do I install Microsoft Equation 3.0 back to Office 365? 0
How can the font and size of (all) citation numbers be altered? 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0

Top