Creating a form based on a spreadsheet in Excel

  • Thread starter Thread starter Sullivan
  • Start date Start date
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?
 
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.
 
Back
Top