Lookup choices controlling calculations

[les@wilcock.plus.com]

Dear members, I would appreciate the help of the forum for what I suspect is a fairly simple task for an experienced programmer.



First some basics, I am running Access 2010 on a Windows 7 platform and attempting to write a simple database for a local charity, and whilst I have basic skills in Access I would not put my level higher that enthusiastic amateur.

The problem
I have a couple of fields, one called 'Income' which is a simple currency field. The second field is called Frequency and is a combo field where the user can choose from Weekly; Monthly; Quarterly; or Annual.

The database user enters data taken from a survey sheet which captures the income of an individual along with the frequency of the payment.

The requirement
I would like to create a calculated field which gives the annual income.
Example:
Income = $5,000 Frequency = Monthly
the calculated field would return (5,000 x 12) = 60,000

Equally
Income = $1,000 Frequency = Weekly would return (1,000 x 52) = 52,000

I suspect it might require VBA code would value any suggestions the members could give.

Regards

Les W

[amrut]

I would suggest to change your field Frequency to numeric type.
Use a combo box (follow wizard which appears when you add a combo box to your form) having two columns.. Type the multiplication factor ( ex 12) in first and description (ex. Monthly) in second.Set column widths to 0;3. Set the Frequency field as control source of this combo box..The users will see the second column only and the multiplication factor will be stored in table. You can get the annual income by simply multiplying the Income and Frequency.

[les@wilcock.plus.com]

Dear Amrut

Thanks for the simple and logical solution.

Works fine

Best Regards