Add 1 field to query

[Bob Vance]

I want to add tblInvoice.ClientDetail to tblInvoice.OwnerName with &"
"&...........Thanks for any help........Bob

SELECT tblInvoice.OwnerID, tblInvoice.OwnerName, tblInvoice.InvoiceDate AS
OnDate,iif(tblInvoice.ClientInvoice=true,tblInvoice.OwnerName,funGetHorse(tblInvoice.InvoiceID)
& " -- " & Format(tblInvoice.OwnerPercent,"0.0%")) AS Description,
tblInvoice.OwnerPercentAmount AS AmountSummary, tblInvoice.InvoiceID,
tblInvoice.InvoiceNo,0 AS Flag
FROM tblInvoice
UNION SELECT tblAccountStatus.OwnerID, NULL, tblAccountStatus.BillDate AS
OnDate, tblAccountStatus.ModeOfPayment AS
Description,(tblAccountStatus.PaidAmount * -1) AS Credit, NULL,BillID,-1 AS
Flag
FROM tblAccountStatus;

 

[John W. Vinson]

I want to add tblInvoice.ClientDetail to tblInvoice.OwnerName with &"
"&...........Thanks for any help........Bob

SELECT tblInvoice.OwnerID, tblInvoice.OwnerName, tblInvoice.InvoiceDate AS
OnDate,iif(tblInvoice.ClientInvoice=true,tblInvoice.OwnerName,funGetHorse(tblInvoice.InvoiceID)
& " -- " & Format(tblInvoice.OwnerPercent,"0.0%")) AS Description,
tblInvoice.OwnerPercentAmount AS AmountSummary, tblInvoice.InvoiceID,
tblInvoice.InvoiceNo,0 AS Flag
FROM tblInvoice
UNION SELECT tblAccountStatus.OwnerID, NULL, tblAccountStatus.BillDate AS
OnDate, tblAccountStatus.ModeOfPayment AS
Description,(tblAccountStatus.PaidAmount * -1) AS Credit, NULL,BillID,-1 AS
Flag
FROM tblAccountStatus;

If anyone here had a way of knowing what tblInvoice.ClinetDetail was, or what
you meant by

with &""&..........

then they might be able to help.

Rather than posting HOW you want to do this, could you post WHAT you want as a
result, and what you're starting with?