ppl,

i need to add a new field/ column to my table. the new field is the difference of two other columns in the table. can i do this without writing a query.
and is there a way i can find the number of working days between two dates... like NETWORKDAYS in excel.

thanks a lot

Yes you can do it without a query.

As it is a derived value then do not have a column in the table for the value.

Whenever you want the difference then calculate it then and yes then you will need a query to select other values and in the same query you can do the calculation

Len

and is there a way i can find the number of working days between two dates... like NETWORKDAYS in excel.

here (http://www.access-programmers.co.uk/forums/showthread.php?t=45584&highlight=days).

I'd suggest that you do a search on bank holidays as I've done loads of threads which calculate public holidays as well as difference between dates, etc.