Creating a form based on a spreadsheet in Excel

S

Sullivan

Hey all

I've been asked to move an application in Excel into
Access. The hardest time I'm having is trying to create
the input form. In the excel, one cell has the following
equation in it (Modified so that the cell names are now
the field names in Access):
=(AmttoBene - (AmttoBene*RO%))* IF(TypeofBene
= "Spouse",0.2,0.1)

How can I do this in a Textbox on a form in Access? And
can I do it in such a way that when a user clicks on "Add
record", it will added to the table as well?
 
M

Mike Painter

Use IIF instead of IF.

It would be better to use a query with this equation in it rather than place
it in a text box.
Once done the query can be used in forms and reports and the equation used
as just another field.

I hope you have modified the information to properly work in a relational
database rather than in the flat file structure of Excel.
 
Top