Tuesday 24 January 2012

[bs-telecom] Digest Number 1636

Messages In This Digest (3 Messages)

Messages

1a.

Re: Query || Related to Microsoft Access

Posted by: "Farhan Ahmed" engr.farhan_ssuet@hotmail.com   farhanb316

Mon Jan 23, 2012 9:07 am (PST)




Haroon,

try to use iif function to replace 0 value to 1. following link might help you

link : http://office.microsoft.com/en-us/access-help/iif-function-HA001228853.aspx

__________________________________________________________
Regards,

Farhan Ahmed
Programmer Analyst
The Shams Group
Karachi, Pakistan
(+92) 345 2523688
View my Certifications

To: bs-telecom@yahoogroups.com
From: haroondada@yahoo.com
Date: Sat, 21 Jan 2012 22:33:59 -0800
Subject: [bs-telecom] Query || Related to Microsoft Access

Hi experts,
Can anyone tell me "How to assign "0" value equal to "1" in MS access Query".I have tried function Nz([field],0) but it assigns NULL values to zero, so what if I want to assign "0' values to "1".

Haroon

1b.

Re: Query || Related to Microsoft Access

Posted by: "Haroon" haroondada@yahoo.com   haroondada

Mon Jan 23, 2012 9:17 am (PST)



Hello Farhan,

Thanks for your help. It worked....:)

Haroon

--- On Sun, 1/22/12, Farhan Ahmed <engr.farhan_ssuet@hotmail.com> wrote:

From: Farhan Ahmed <engr.farhan_ssuet@hotmail.com>
Subject: RE: [bs-telecom] Query || Related to Microsoft Access
To: "Telecom Group" <bs-telecom@yahoogroups.com>
Date: Sunday, January 22, 2012, 11:40 PM

 

Haroon,

try to use iif function to replace 0 value to 1. following link might help you

link : http://office.microsoft.com/en-us/access-help/iif-function-HA001228853.aspx

__________________________________________________________
Regards,

Farhan Ahmed
Programmer Analyst
The Shams Group
Karachi, Pakistan
(+92) 345 2523688     
View my Certifications

To: bs-telecom@yahoogroups.com
From: haroondada@yahoo.com
Date: Sat, 21 Jan 2012 22:33:59 -0800
Subject: [bs-telecom] Query || Related to Microsoft Access

Hi experts,
Can anyone tell me "How to assign "0" value equal to "1" in MS access Query".I have tried function Nz([field],0) but it assigns NULL values to zero, so what if I want to assign "0' values to "1".

Haroon



2.

Help || Need Assistance For Test Preparations

Posted by: "usman" manihrp@yahoo.com   manihrp

Mon Jan 23, 2012 9:16 am (PST)



Hello,

Can any body tell me any good site or link from where i could prepare MCQ's type questions of GSM, networking, data communication/ digital communication, wireless communication , cdma, 3G, SS7......etc. Please tell me a quality website in which MCQ's cover in depth of every topic waiting for your reply

Thanks
Usman

Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! Groups

Mental Health Zone

Learn about issues

Find support

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
*Please consider the environment before printing this e-mail*

This electronic message contains information from bs-telecom A Virtual Forum which may be privileged or confidential. The information is intended to be for the use of the member(s)or entity named above. If you are not the intended recipient please destroy this message immediatly. Please don�t send/share confidential OWNED information material, bs-telecom bears no responsibility of the contents of the email.
Best Of Luck for your Future BS-Telecom


No comments:

Post a Comment