Calculated field in form view

[Bob Reynolds]

Hello, MS Access 2003. I have a form and have 5 fields that were
calculations in MS Excel. This db has been imported from Excel.

My problem: Placing a field in the form view that will do calculations on
other fields and merged those fields.
Fields
BusType
ERDBA
ERFULLNAME
ERCO
NameMerge
ERFname
ERMI
ERLname
SPDBA


Problem:


NameMerge excel formula
=IF(BUSTYPE="",ERFULLNAME,IF(BUSTYPE="SP",ERFULLNAME,IF(BUSTYPE="Part",ERCO,IF(BUSTYPE="Corp",ERCO,""))))
***used to merge a calculated fullname of an employer with the company name.

SPDBA EXCEL FORMULA =IF(BUSTYPE="",NAMEMERGE,IF(BUSTYPE="SP",NAMEMERGE &
DBAMERGE,IF(BUSTYPE="Part",NAMEMERGE & DBAMERGE,IF(BUSTYPE="Corp",NAMEMERGE
& DBAMERGE,""))))
***used to calculate some nulls and then either produce a merged name or a
merged name and a dba name.

DBAMERGE =IF(BUSTYPE="",ERDBA,IF(BUSTYPE="SP"," dba " &
ERDBA,IF(BUSTYPE="Part"," dba " & ERDBA,IF(BUSTYPE="Corp"," dba " & ERDBA,
""))))
***used to calculate the dba name and actually insert the "dba" into the
name..

ERFULLNAME =CONCATENATE(IF(ERFNAME="","",ERFNAME2),IF(ERFNAME="","","
"),IF(ERMI="","",ERMI),IF(ERMI="",""," "),ERLNAME)
***used to calculate a person's full name from three fields.


All of the basic fields are in access when I imported them over. How do I
get these into a field titled as indicated above and have it automatically
calculate the product so that I can merge it with a mail merge document in
WORD.

Any help would be appreciated.
Bob Reynolds

 

[Brendan Reynolds]

You can't use expressions like this in tables in Access, but you can do it
in a query, form or report. Access has an IIF function that is similar to
the Excel IF function. Check out the link below, you should find some
examples there ...

http://office.microsoft.com/en-gb/assistance/CH790018001033.aspx

(You can change the 'gb' in the above URL to 'us' for the US site.)