formatting results in a union query

[Guest]

this is probably really simple!

I have a union query which lists financial data as either credit or debt, so
a cheque paid into the acount is a credit and an invoice charge is a debt. I
use the following code to build up Union Query:

SELECT cheque.datebanked AS [Bank Date], "Cheque Payment" AS [Charge Type],
cheque.Amount AS Amount, Receipt.ReceiptNo, cheque.Amount AS Credit, Null AS
Debt, Receipt.Student AS StudentReference
From....

The debt for cheques is null and every subsequent debt has no field
formating, so it doesnt show up as a monetary payment!! This query forms the
basis of a report, cani just format the field in the report or is it possible
to do it here?

With much thanks,

Amit

 

[Michel Walsh]

Hi,




Try:


iif( false, CCur(0), Null ) As Debt



Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

I didnt think to use conditional formatting in the SQL view, it seems kinda
obvoius when its in the QBE view. Ive been given a new priority task to do so
ill be enacting your ideas later on in the day, but it looks good to me.

With much thanks

Amit