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: Files imported into access from excel with calculations
that were used there to get the calculaitons.
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 as I am very inexperienced with
access. Thank you
Bob Reynolds
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
