[mso] Access if and then if

From: Karen Willingham <kwillingham@xxxxxxxxxxxxxxxxxxxxxxxxx>
To: "'mso@xxxxxxxxxxxxx'" <mso@xxxxxxxxxxxxx>
Date: Thu, 21 Aug 2003 13:11:51 -0500

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
*************************************************************

[mso] Access if and then if

Other related posts: