Field that is made up by concatenating two other fields in the same table

[gheyman]

I am Very new to Access, so please keep that in mind if you reply.

I have a table where I want one of the fields to concatenate fields

Fields "Sector/Division" & "Corporation"

I want to do the Excel equivalent of

If "Sector/Division" is not null Then
x=Concatenate(Sector/division,", "Corporation)
Else
x=Corporation
End If.....

Thanks. Much appreciated.

 

[Joe4]

Is your intention to get rid of the "Sector/Division" field altogether (i.e. make this a permanent change), or are you just looking at doing this for the purposes of one query, report, etc.?

 

[gheyman]

No, I cannot get rid of Sector. When a user is entering a new customer to the Tables, some times they do not have both the division of the company and the corporate name. Example Lockheed, Missiles and Guidance Systems. Lockheed has hundreds of divisions. So I need to know both. But then there are going to be times where the person entering data doesn't know the Division at the time of entry or may never know (some corporations don't have division).

 

[Joe4]

OK, then you just want to do that as a calculated field in a query, and that calculation would look like:

IIf([Sector/Division] Is Null,[Corporation],[Sector/Division] & [Corporation])

 

[gheyman]

Thanks, That worked

 

[Joe4]

You are welcome!