|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
March 27th 06, 12:52 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
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 
|
|
#2
March 27th 06, 06:45 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
|
|
#3
March 28th 06, 09:30 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need a link to report a bug | Gyurika | Outlook - Using Contacts | 1 | February 26th 07 07:00 PM |
| Sending HTML format report is not working | [email protected] | Outlook - General Queries | 3 | March 16th 06 07:07 PM |
| Sending HTML format report is not working | [email protected] | Outlook - General Queries | 0 | March 16th 06 05:47 PM |
| Error report on returned mail. | Buiskop19 | Outlook Express | 13 | February 24th 06 02:26 PM |
Hybrid Mode
