Monthly outstanding query

rickyfong

Registered User.
Local time
Today, 06:50
Joined
Nov 25, 2010
Messages
199
2 tables, one is customer table and the other is invoice table. I would like to have a queries for each customer and 12 columns indicated 12 months, with monthly outstanding figure showing per column. Just want to know how to put the condition in the condition row! Thanks!!
 

Users who are viewing this thread

Back
Top Bottom