CaculatinQuerys

  • Thread starter Thread starter Robin
  • Start date Start date
R

Robin

I need to add a query that can add and subtract no's from
a number of field on a form.
 
The following example assumes that there is a form called frmTest, that it
includes a text box named txtTest, that the form is open when the query is
run, and that the text box contains a number when the query is run.
'TestNumber' is the name of a field in the table 'tblTest'.

SELECT [Forms]![frmTest]![txtTest]-[TestNumber] AS MyDeduction,
[Forms]![frmTest]![txtTest]+[TestNumber] AS MyAddition
FROM tblTest;
 
You must log in or register to reply here.

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

How to subtract a number from a Mergefield? 0
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Set up a checkbox or other control for "do this" or "do that"? 5
Excel Formula or equation 3
Time Calculations..subtracting Minutes 3
calculate fields in different tables 6
How do I calculate and store results? 3
How do I calculate and store results? 5

Back
Top