Am I able to base, say, query field 3 on the results of query field 1 and 2?
For example, Field 1 is [Balance]/100 and then renamed “new balance”. Field 2 is [Transaction]/100 and renamed “new transaction”. I then want to enter in the third Field simply, [new balance] + [new transaction]. When I do this and run the query I get the “Enter Parameter Value” box pop up for “new balance” and “new transaction”.
When I click OK on the boxes the correct results are displayed, but I would like to run the query without the boxes popping up – is this possible?
Or is the only way to prevent the boxes popping up to calculate everything in the one field ie ([Balance]+[Transaction])/100
Thank you in advance!
For example, Field 1 is [Balance]/100 and then renamed “new balance”. Field 2 is [Transaction]/100 and renamed “new transaction”. I then want to enter in the third Field simply, [new balance] + [new transaction]. When I do this and run the query I get the “Enter Parameter Value” box pop up for “new balance” and “new transaction”.
When I click OK on the boxes the correct results are displayed, but I would like to run the query without the boxes popping up – is this possible?
Or is the only way to prevent the boxes popping up to calculate everything in the one field ie ([Balance]+[Transaction])/100
Thank you in advance!