putting a calculated field in a table

[chris M]

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 (row), 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 these two columns 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














=IF(AND(J6<>"",(NETWORKDAYS(J6,K6,nameoffile2008.xls!holidays))-1>=0),(NETWORKDAYS(J6,K6,nameoffile2008.xls!holidays)-1),"")

 

[KARL DEWEY]

Access tables store data but do not do calculations. Math is done in
queries, forms, or reports.
You can not put a formula in an Access field like in Excel.