[mso] Re: Access... Div/0 Error :VSMail mx2
- From: James LaBorde <jlaborde@xxxxxxxxx>
- To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
- Date: Fri, 3 Jan 2003 08:50:53 -0800
April,
I have actually been trying that. IsError is there but I can't figure out
what it is returning to use it as criteria. In Access you actually have to
put the equation in, in your IIF statement. So if you can find what the
IsError returns you could do something like:
IIF(ISError([fieldone]/[fieldtwo])=Result, "No Data", [Fieldone]/[fieldtwo])
The problem is I can't find what it returns. Most of the time "True" in
Access = -1, however, that is not the case in this instance. What you may
end up having to do is:
IIF([fieldtwo] = 0, "No Data", [fieldone]/[fieldtwo])
This should work for you since Access can handle dividing zero just not
dividing by zero.
I hope this helps a little. If not, hopefully one of the other Access
people on this list has had to use this before and figured out the IsError
value.
James
-----Original Message-----
From: 4office [mailto:4office@xxxxxxxxxxxxx]
Sent: Friday, January 03, 2003 8:22 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Access... Div/0 Error :VSMail mx2
James, So how do I test for an Error?? as my condition??
IIF(ISERROR([FieldOne]/[FieldTwo]),"No Data", [FieldOne]/[FieldTwo]) I did
not see ISERROR as a condition that I can test on.
April
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
Behalf Of James LaBorde
Sent: Tuesday, December 31, 2002 2:13 PM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Re: Access... Div/0 Error :VSMail mx2
April,
Access has an If statement too. Its syntax is almost the same:
IIF(condition, true statement, false statement)
James
-----Original Message-----
From: 4office [mailto:4office@xxxxxxxxxxxxx]
Sent: Tuesday, December 31, 2002 10:52 AM
To: Office (E-mail)
Subject: [mso] Access... Div/0 Error :VSMail mx2
(In a different DB then the one mentioned in my last LONG posting) I have a
query that divides one field by another... When there is a 0 (zero) to be
the divided by number, I get the Div/0 Error.... Now In Excel, I would
simple do an If(IsError(A1/B1),"No data",A1/B1) How do I do this in Access??
April
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions. Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
