ACCESS FEED: RE: [MS_AccessPros] Query Not seen

Minggu, 07 April 2013

RE: [MS_AccessPros] Query Not seen

Shekar-

What is the SQL of your query? Are you saying when you set the balance to 0
in the form that other fields go blank? That could be a result of the
filter, but I would need to see the SQL to be sure.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of tchshekar
Sent: Sunday, April 07, 2013 4:21 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Query Not seen

Hi
I have made a query with customer, Invoice, Invoice Balance, which is being
pulled to Form, with criteria to show only those invoices which have balance
of more than 0,, but once the Balance of invoice becomes zero, the form from
where the entry is done Customer feild is left blank.

KIndly help

Thanks

Shekar

[Non-text portions of this message have been removed]