S
Stephanie
HI I'm new to access and I need to to some calculations in it. I'm doing them
in a query. I have a few problems. I tried before to do the Iif statement but
somehow it returned almost 2 million results and then froze on me. I want to
end up with a query where 4 fields are calculated simultanously. 2 of these
are Iif calculations and the others are simple multiplications or
subtractions. my problems are this:
1. in the design of the query what do I put in the field box? ( i want this
to be a new field)
2. some of the calculations are based on values that are in two separate
tables. (will this work)
3. calculations are cascading, ie the second one uses the result of the
first and the 3rd uses the result of the 2nd etc. however all numbers are
important and need to be viewable.
so can I do this? please help!! and include details in your answers incase
it's something fiddly im just missing right now.
Thanks!
in a query. I have a few problems. I tried before to do the Iif statement but
somehow it returned almost 2 million results and then froze on me. I want to
end up with a query where 4 fields are calculated simultanously. 2 of these
are Iif calculations and the others are simple multiplications or
subtractions. my problems are this:
1. in the design of the query what do I put in the field box? ( i want this
to be a new field)
2. some of the calculations are based on values that are in two separate
tables. (will this work)
3. calculations are cascading, ie the second one uses the result of the
first and the 3rd uses the result of the 2nd etc. however all numbers are
important and need to be viewable.
so can I do this? please help!! and include details in your answers incase
it's something fiddly im just missing right now.
Thanks!