Formula within Table Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Good Day,
If any one can help me for the following.
1, Table expamples with normalization.
2. How can put date calculation formula within the table
properties.
Like I would like to create table of three fields one will
carry date of
Certificate and second one say 90 days validity and third
would like to
have with the formula, showing expiry date of Certificate.
([CertificateDate]+[90] [Expiry date]

3. Form field calculation. [VehicleParking date with time] -
[VehicleDroveOut date time] =[Result field, mean how much time vehicle was in
parting] Result field should be in day and hours. One minute mean should
be one hour. no decimal figure required.

If some one could help me.

regards,
 
A1. Normalization.
Big topic. Heres a start:
Description of database normalization basics in Access 2000
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209534

A2. Calculated fields.
This cannot be done at the table level.

For an explanation of how and when to store a dependent value, see:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Table-level field calculations are not possible with any DB. If you're
looking to do calculations on field values, you can put an expressing
into a QUERY, however if you have a lot of calculated fields and/or a
lot of records returned by the QUERY it will dramatically slow down the
query. It is not recommended unless absolulately neccesssary. The
alternatives are to create controls with controlSources that are
caluclated. For example, if you needed to show the date that a
certificate expires on a form you would create a control with the
..ControlSource set to = [CertificateDate] + 90
 
David,
Thank you for your valued time you spent.
Now will put my consentration on to develop quary.

thanks
--
Access Keen User



David C. Holley said:
Table-level field calculations are not possible with any DB. If you're
looking to do calculations on field values, you can put an expressing
into a QUERY, however if you have a lot of calculated fields and/or a
lot of records returned by the QUERY it will dramatically slow down the
query. It is not recommended unless absolulately neccesssary. The
alternatives are to create controls with controlSources that are
caluclated. For example, if you needed to show the date that a
certificate expires on a form you would create a control with the
..ControlSource set to = [CertificateDate] + 90
Hi,
Good Day,
If any one can help me for the following.
1, Table expamples with normalization.
2. How can put date calculation formula within the table
properties.
Like I would like to create table of three fields one will
carry date of
Certificate and second one say 90 days validity and third
would like to
have with the formula, showing expiry date of Certificate.
([CertificateDate]+[90] [Expiry date]

3. Form field calculation. [VehicleParking date with time] -
[VehicleDroveOut date time] =[Result field, mean how much time vehicle was in
parting] Result field should be in day and hours. One minute mean should
be one hour. no decimal figure required.

If some one could help me.

regards,
Click to expand...
Click to expand...
 
Back
Top