Gap Before a Name

B

Bob V

Is it possible to have a gap before OwnerLastName , '',
thanks in Advance if you can help..........Bob

Name:
IIf(IsNull([tblOwnerInfo].[OwnerLastName]),'',[tblOwnerInfo].[OwnerLastName]
& ', ') &
IIf(IsNull([tblOwnerInfo].[OwnerFirstName]),'',[tblOwnerInfo].[OwnerFirstName])
 
A

akphidelt

IIf(IsNull([tblOwnerInfo].[OwnerLastName]),'',[tblOwnerInfo].[OwnerLastName]
& ', ') & " " &
IIf(IsNull([tblOwnerInfo].[OwnerFirstName]),'',[tblOwnerInfo].[OwnerFirstName])

Insert " " & from the code above
 
B

Bob V

Sorry I wanted " gap" LastName ",Gap" FirstName
Thanks Bob

akphidelt said:
IIf(IsNull([tblOwnerInfo].[OwnerLastName]),'',[tblOwnerInfo].[OwnerLastName]
& ', ') & " " &
IIf(IsNull([tblOwnerInfo].[OwnerFirstName]),'',[tblOwnerInfo].[OwnerFirstName])

Insert " " & from the code above

Bob V said:
Is it possible to have a gap before OwnerLastName , '',
thanks in Advance if you can help..........Bob

Name:
IIf(IsNull([tblOwnerInfo].[OwnerLastName]),'',[tblOwnerInfo].[OwnerLastName]
& ', ') &
IIf(IsNull([tblOwnerInfo].[OwnerFirstName]),'',[tblOwnerInfo].[OwnerFirstName])
Click to expand...
Click to expand...
 

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

Recordset is not updateable after adding a query 7
First Character of First Name! 5
Adding a Blank between Names! 1
Only want the first 3 letters to show 3
Incorporate a space into a string 11
Report Error "Database Engine" 5
2 DBs 1 giving a query error 1
2 dbs one gets error 3

Top