complicated (sort of) equations in access

[Guest]

I am designing a lakes database and one of the functions is that i want it to
take the management objective (ie tbl 1) and combine it with survey
information like size (ie tbl 2) and calculate the angling potential. these
are multiple step calculations that are currently done in excel. for instance
you take calculate the number of days from the perimeter or area like this
:=IF(E2*I2/100>100,E2*I2/100,D2*I2) and then use that number to calculate the
number of commercial days by using a percent of that based on the management
objective. (sorry if this is sounding confusing.)

there are also several other calculations that are then done......

basically i want to know if access can do this and what is the best way to
go about it. My background is in excel but i've been doing a fair amount of
access design lately.

or is there a way that excel can pull out the few fields that it needs and
then output the results back into an access table??

Really any help would be appreciated, I'm kinda stumped right now.

 

[John Vinson]

basically i want to know if access can do this and what is the best way to
go about it. My background is in excel but i've been doing a fair amount of
access design lately.

Yes. You can do quite complex expressions in a Query, or in the
control source of a textbox on a Form or Report. The syntax is
different of course - your expression

=IF(E2*I2/100>100,E2*I2/100,D2*I2)

might translate to

NewFieldname: IIF([E]*/100 > 100, [E]*/100, [D]*)

or is there a way that excel can pull out the few fields that it needs and
then output the results back into an access table??

That's doable too with some more effort.

You can also write custom VBA functions (think "macros" in Excel
jargon, Access Macros aren't useful for this kind of thing) to do just
about anything any programmatic language can do.

John W. Vinson[MVP]