Auto insert a value dependant on the previous fields content

[Guest]

Using Access in Office 2000...I wish to have a field auto fill a value based
on the result of the contents of another field in the same entry form: ie
Field 1) entry = "1st"..............Auto fill in field 2 ......number "1"
Field 1) entry = "2nd".............Auto fill in field 2.......number ".5"

that's all, seems simple and in Excel it's a piece of cake I know, but can't
figure it out in Access......Help !!!
Brian Healey

 

[Sue Mosher [MVP-Outlook]]

Try asking in an Access group. This one is for Outlook programming.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers