I want to prepare a report of all fields not equal to zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In MS-Access For prepring payslips in a payroll system I want to pickup all
those variables from tables or query having zero or null values. please help
me as soon as possible.

Aijaz
 
Am Sun, 26 Mar 2006 14:52:55 -0800 schrieb
(e-mail address removed):

Are you looking for a select statement or do you have the Recordset in VBA
already?
 
I'm not really sure what you whant or what the problen is, but I think
what you need is some ADODB-Select (Recordset) and a select like

SELECT F_A, F_B, F_C FROM T1 WHERE F_D IS NULL OR F_D = 0

Klaus
 
Back
Top