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

  • Thread starter what do you mean by display name
  • Start date
W

what do you mean by display name

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
 
K

Klaus

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
 
Top