Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   I want to prepare a report of all fields not equal to zero (http://www.outlookbanter.com/outlook-vba/9485-i-want-prepare-report-all.html)

what do you mean by display name March 27th 06 12:52 AM

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


Michael Bauer March 27th 06 06:45 AM

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


Klaus March 28th 06 09:30 PM

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 09:14 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