G
Guest
I have included the SQL of this union query. For some reason when I run the
query the "Withdrawal" field looks like Chinese or Wingding characters.
However, if I run each half of the union query individually the resulting
records are just fine - no Chinese characters in the "withdrawal" field.
I thought it was a busted formula, yet when I ran the report based on the
union query it displays the Chinese characters, but calculated fields based
on the "withdrawal" field with Chinese character are calculating properly.
It is like something is screwed up with the displaying of that field in a
union query - yet the value of this field is prevailing since calculations
are still functioning correctly.
All help is appreciated.
Seth
SELECT tblProject.ProjectNo, tblProject.Name, tblProject.Date AS
ProjectDate, tblDeposit.Date AS TransDate,
IIf(IsNull([lname]),[business],[lname] & ", " & [fname]) AS FullName,
tblDeposit.Amount AS Deposit, Null AS Withdrawl
FROM (tblClients INNER JOIN tblProject ON tblClients.ClientNo =
tblProject.Clientno) INNER JOIN tblDeposit ON tblProject.ProjectNo =
tblDeposit.ProjectNo
WHERE (((tblProject.Complete)=False))
UNION SELECT tblProject.ProjectNo, tblProject.Name, tblProject.Date AS
ProjectDate, tblPayment.Date AS TransDate,
IIf(IsNull([lname]),[business],[lname] & ", " & [fname]) AS FullName, Null AS
Deposit, tblPayment.Amount AS Withdrawl
FROM ((tblClients INNER JOIN tblProject ON tblClients.ClientNo =
tblProject.Clientno) INNER JOIN tblOrder ON tblProject.ProjectNo =
tblOrder.ProjectNo) INNER JOIN tblPayment ON tblOrder.OrderNo =
tblPayment.OrderNo
WHERE (((tblProject.Complete)=False));
query the "Withdrawal" field looks like Chinese or Wingding characters.
However, if I run each half of the union query individually the resulting
records are just fine - no Chinese characters in the "withdrawal" field.
I thought it was a busted formula, yet when I ran the report based on the
union query it displays the Chinese characters, but calculated fields based
on the "withdrawal" field with Chinese character are calculating properly.
It is like something is screwed up with the displaying of that field in a
union query - yet the value of this field is prevailing since calculations
are still functioning correctly.
All help is appreciated.
Seth
SELECT tblProject.ProjectNo, tblProject.Name, tblProject.Date AS
ProjectDate, tblDeposit.Date AS TransDate,
IIf(IsNull([lname]),[business],[lname] & ", " & [fname]) AS FullName,
tblDeposit.Amount AS Deposit, Null AS Withdrawl
FROM (tblClients INNER JOIN tblProject ON tblClients.ClientNo =
tblProject.Clientno) INNER JOIN tblDeposit ON tblProject.ProjectNo =
tblDeposit.ProjectNo
WHERE (((tblProject.Complete)=False))
UNION SELECT tblProject.ProjectNo, tblProject.Name, tblProject.Date AS
ProjectDate, tblPayment.Date AS TransDate,
IIf(IsNull([lname]),[business],[lname] & ", " & [fname]) AS FullName, Null AS
Deposit, tblPayment.Amount AS Withdrawl
FROM ((tblClients INNER JOIN tblProject ON tblClients.ClientNo =
tblProject.Clientno) INNER JOIN tblOrder ON tblProject.ProjectNo =
tblOrder.ProjectNo) INNER JOIN tblPayment ON tblOrder.OrderNo =
tblPayment.OrderNo
WHERE (((tblProject.Complete)=False));