![]() |
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 |
All times are GMT +1. The time now is 08:02 AM. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com