Calculations

[Milind]

If value of a field depends on the other, how does one go about it in Access?
I need to use this resultant value for a Yes/No in a third field. My data is
beyond the capacity of Excel (even 2007) as the records are in excess of
500,000 per month.

 

[Jeff Boyce]

Access tables do not have a way to calculate one field value based on
another. Also, this violates principals of normalization, that state that
no field should be dependent on another.

Moreover, storing calculated values is rarely necessary (and carries
additional programming requirements) ... you can usually use a simple query
to "calculate", based on values in the table.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Douglas J. Steele]

Jeff's correct that you'd put the calculations into a query, not try to
store them in a table.

However, Excel 2007 has a capacity of 1,048,576 rows (by 16,384 columns)
http://office.microsoft.com/en-us/excel/HA100738731033.aspx#MoreRowsColumns