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

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

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

Am Sun, 26 Mar 2006 14:52:55 -0800 schrieb
:

Are you looking for a select statement or do you have the Recordset in VBA
already?

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


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

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

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

Michael Bauer wrote:
Am Sun, 26 Mar 2006 14:52:55 -0800 schrieb
:

Are you looking for a select statement or do you have the Recordset in VBA
already?

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


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