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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crating User Form to Add Names 1
Merging from an Excel file with graphics 1
Word macro that can call cells out of Excel for a find and replace 0
How do I clear a form? 0
Need Help Creating a Word Template using Excel 1
Reading excel spreadsheet 2
Using Forms to Export Data from an Access Table to an Excel Spreadsheet 1
Need to create a form (word or excel) that feeds in to a spreadsheet ..BUT 0

Top