new column

[tintin16]

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

 

[Len Boorman]

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

 

[Mile-O]

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

here.

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.