C

#### chris M

Question sorry, please ignore the previous post, here is the correct one

I am completely lost. I can do this in excel, but because the whole

application must be migrated to Access, I do not know how to do this. Any

help would be so appreciated I cant even begin to tell you.

In Excell, I have a column called "open" date, a column called "close" date,

and a column called "time between". For each record I put a date in

for Open date cell and the Close date cell. I have a formula that causes the

"time between" column to fill in automatically, as it calculates the number

of days between "open" and "close", taking into account weekends.

The Formula in the "time between" column is a canned Excell formula called

"Networkdays".

I have also put in a holiday range on my spreadsheet that lists our holidays

for the current year.

Here is the Excel formula "Networkdays", with my Holiday range put in:

Please ignore the cell address references:

=IF(AND(J7<>"",(NETWORKDAYS(J7,K7,spreadsheetname.xls!holidays))-1>=0),(NETWORKDAYS(J7,K7,spreadsheetname.xls!holidays)-1),"")

This formula works. But how do I set this up in a field table in Access?

Does Access know what the formula "Networkdays" from Excell is?

HELP!!!

Thanks, chris