formulas

[angie]

i want a particular field in a table to be completed automatically if certain criteria in another field are met.

i have achieved that in excel by using the if function. could i aim for that to work in access? which is the path?

 

[Allen Browne]

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.

i want a particular field in a table to be completed automatically if

certain criteria in another field are met.

i have achieved that in excel by using the if function. could i aim for

that to work in access? which is the path?