[mso] Re: Access if and then if :VSMail mx3

From: James LaBorde <jlaborde@xxxxxxxxx>
To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
Date: Fri, 22 Aug 2003 09:28:57 -0700
Karen,

Your solution may be a little simpler than you are trying to make it.  I
would do something like this:

If [pack] = 1, [BottlePrice], [CasePrice])

This would meet the criteria you specified toward the end of your email. If
you need to embed multiple IF statements the syntax would read:

If expresion Then
        Do Something
Else 
        If expression Then
                Do something
        End If
End If

VBA has some peculiarities as you can see.

The first one shoudl work just fine for you though.  If you wanted to you
could actually move it to a calculated field in your query:

SalePrice: IIF([pack] = 1, [BottlePrice], [CasePrice])

James


-----Original Message-----
From: Karen Willingham [mailto:kwillingham@xxxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Thursday, August 21, 2003 11:12 AM
To: 'mso@xxxxxxxxxxxxx'
Subject: [mso] Access if and then if :VSMail mx3


I need to write this but do not know the best way.  Access 2000, in a
report, in a Text Box.

I need something like this -->

this part I am not sure of at all 
        Private Sub Detail_???t(Cancel As Integer, FormatCount As Integer)
        If
                [LIST_CASE] =  If ([pack] > 1, [CasePirce],Null)
        then if
                [LIST_CASE] = if ([CasePrice] = [BottlePrice], [CasePrice],
null)   



Private Sub Detail_???t(Cancel As Integer, FormatCount As Integer)
        If
                [LIST_BOTTLE] =  If ([pack] > 1,Null, [BottlePrice])
        then if 
                [LIST_BOTTLE] = if ([CasePrice] = [BottlePrice], null,
[BottlePrice])  

I am trying to do a work around. I did this database over 2 years ago.
Asking as many questions as possible at the time. Now they are taking what I
did in Access and inputting in to there AS400 for pricing. I have a the same
price in the Case Price and the Bottle price if the Pack is = to 1. I need
to keep that like it is for all the 60 reports that was done 2 years ago.
The 60 reports are all done different and have one column for pricing
depending on now they buy it from us. This new form has 2 columns. But only
want to show the price how they buy it from us case or bottle cost. 

Please help

Karen
*************************************************************
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 with the word "unsubscribe" (without the quotes)
in the subject line.

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 with the word "unsubscribe" (without the quotes) in 
the subject line.

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
*************************************************************
[mso] Re: Access if and then if :VSMail mx3

Other related posts:
