Access gurus who knows Excel formula - HELP!

[Hawkeye-X]

=IF('CURRENT DMR'!W35="","",('CURRENT
DMR'!W35*'CURRENT DMR'!E35*8.34)*(COUNT('CURRENT
DMR'!A4:A34)))

In Access, 

CURRENT DMR!W35 is [AvgLTCTotalP] 
CURRENT DMR!E35 is [AvgLTC]

A4-A34 represents the dates (It needs to know how many days in
a month, since it is a monthly report)

So help me out!

Thanks,

Hawkeye-X

[BootinUp]

1. It wouldn't be much different

Where do you want the answer displayed? on a form or a report I guess?

Are you storing the variables in Access tables?

[Hawkeye-X]

2. The variable is in Access tables

and I'm trying to put it in a query form.

Thanks!

Hawkeye-X

[BootinUp]

3. I'd create a function

Go to Modules and make a general purpose module "Module1". Then make a function.

Function yourfunctionname(AvgLTCTotalP,AvgLTC)

code to calculate result

yourfunctionname=result

End Function


Now call the function from the query and supply the two variables.

ok?