Parameters in calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do a set up a parameter in a query using Access 2000. Once a value is
entered, how do I use it in a calculation. This is what I did but it is not
working.

Column 1 Pre Committed Capital Emergency
Balance

Criteria [Fiscal 2000] $69,204 Fiscal
2000 - $692,04

I entered $25,000,000 for Fiscal 2000
The equation gave me a value of $149,93 0,769.00 for emergency Balance
 
It sounds like you have the right concept. You should
have a field from your table called Capital, a criteria
field ([Fiscal 2000]) and then the Balance field is the
difference. Your fields should look like so:
Capital
[Fiscal 2000]
Balance: [fiscal 2000] - [capital]

I tried this out and it does get the correct number. Make
sure you use the square brackets when referring to a field
whether it is a criteria field or a field from a table.

Hope it helps!

Jessica
-----Original Message-----
How do a set up a parameter in a query using Access 2000. Once a value is
entered, how do I use it in a calculation. This is what I did but it is not
working.

Column 1 Pre Committed Capital Emergency
Balance

Criteria [Fiscal 2000]
Click to expand...
$69,204 Fiscal
 
Back
Top