formatting results in a union query

  • Thread starter DowningDevelopments
  • Start date
D

DowningDevelopments

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
 
M

Michel Walsh

Hi,




Try:


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



Hoping it may help,
Vanderghast, Access MVP
 
D

DowningDevelopments

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
 

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

Top