Using a Yes/No field to trigger a calculation in another field - J 03-24-10

I am trying to use an IIF statement to have a filed calculate based on 
another field having either Yes or No in it.  The fields are:

TotalTuitions - all the tuitions added together
MultiClassTrigger - Yes/No fiield
MultiClassDisc - 10% discount to be calculated depending on Yes/No

IIF statement  -  
MultiClassDisc:IIf([MultiClassTrigger]=Yes,[TotalTuitions]*0.1,0)

This will work the first time that Yes is selected in the Trigger field but 
then the value will stay when I change the Trigger field back to No.  With No 
selected it should change the discount field back to zero.

I know I am missing something but can't come up with anything that will 
work.  Any suggestions would be appreciated.   Thanks.
-- 
JCW
0
Utf
3/24/2010 2:19:01 AM
access.queries 6343 articles. 1 followers. Follow

7 Replies
957 Views

Similar Articles

[PageSpeed] 9

Hi John,

Put your code in the afterupdate event of Multiclass trigger.

Every time you update thr MultiClassTrigger the MultiClassDiscount will 
reset.

Regards

kevin


"JohnW" <JohnW@discussions.microsoft.com> wrote in message 
news:5500BAEC-B9FC-440E-BB91-789AAF637C2B@microsoft.com...
>I am trying to use an IIF statement to have a filed calculate based on
> another field having either Yes or No in it.  The fields are:
>
> TotalTuitions - all the tuitions added together
> MultiClassTrigger - Yes/No fiield
> MultiClassDisc - 10% discount to be calculated depending on Yes/No
>
> IIF statement  -
> MultiClassDisc:IIf([MultiClassTrigger]=Yes,[TotalTuitions]*0.1,0)
>
> This will work the first time that Yes is selected in the Trigger field 
> but
> then the value will stay when I change the Trigger field back to No.  With 
> No
> selected it should change the discount field back to zero.
>
> I know I am missing something but can't come up with anything that will
> work.  Any suggestions would be appreciated.   Thanks.
> -- 
> JCW 


0
kc
3/24/2010 2:27:09 AM
Kevin

When I put in my IIF statement into the afterupdate of the MultiClassTrigger 
field it gives me a "The expression you entered contains invalid syntax" "You 
may have entered an operand without an operator.

I am using 

MultiClassDisc:IIf([MultiClassTrigger]=Yes,[TotalTuitions]*0.1,0)

Suggestions?  Thanks

-- 
JCW


"kc-mass" wrote:

> Hi John,
> 
> Put your code in the afterupdate event of Multiclass trigger.
> 
> Every time you update thr MultiClassTrigger the MultiClassDiscount will 
> reset.
> 
> Regards
> 
> kevin
> 
> 
> "JohnW" <JohnW@discussions.microsoft.com> wrote in message 
> news:5500BAEC-B9FC-440E-BB91-789AAF637C2B@microsoft.com...
> >I am trying to use an IIF statement to have a filed calculate based on
> > another field having either Yes or No in it.  The fields are:
> >
> > TotalTuitions - all the tuitions added together
> > MultiClassTrigger - Yes/No fiield
> > MultiClassDisc - 10% discount to be calculated depending on Yes/No
> >
> > IIF statement  -
> > MultiClassDisc:IIf([MultiClassTrigger]=Yes,[TotalTuitions]*0.1,0)
> >
> > This will work the first time that Yes is selected in the Trigger field 
> > but
> > then the value will stay when I change the Trigger field back to No.  With 
> > No
> > selected it should change the discount field back to zero.
> >
> > I know I am missing something but can't come up with anything that will
> > work.  Any suggestions would be appreciated.   Thanks.
> > -- 
> > JCW 
> 
> 
> .
> 
0
Utf
3/25/2010 1:05:01 AM
If you are doing this in VBA, you need to put

    IIf([MultiClassTrigger]=True,[TotalTuitions]*0.1,0)

into the VBA code.  You should have
   [Expression]
in the After Update property and then click the three dots at the end to open 
the VBA window and put the above statement in the code.

I would do this slightly different.  I would set the control source of 
TotalTuitions to the expression.
=IIf([MultiClassTrigger]=True,[TotalTuitions]*0.1,0)

And it might be necessary for you to force a recalc of the totalTuitions 
control when you change the value of the MultiClassTrigger control. If the 
total tuitions control fails to update try putting the following in the after 
update event code of the MultiClassTrigger control.
    Me.TotalTuitions.Requery


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

JohnW wrote:
> Kevin
> 
> When I put in my IIF statement into the afterupdate of the MultiClassTrigger 
> field it gives me a "The expression you entered contains invalid syntax" "You 
> may have entered an operand without an operator.
> 
> I am using 
> 
> MultiClassDisc:IIf([MultiClassTrigger]=Yes,[TotalTuitions]*0.1,0)
> 
> Suggestions?  Thanks
> 
0
John
3/25/2010 12:26:18 PM
John
I am not sure if I am following.  I am tryin to use the MultiClassTrigger 
field to force the calculation of the MultiClassDisc field.  When the Trigger 
field is clicked to Yes I need it to take TotalTuitions*.1 to calculate the 
10% discount.  When it is clicked No I want MultiClassDisc to equal zero.

Maybe this is what you're trying to do but when I put the code in the after 
update field nothing is happening.

I apprecaite your help and patience.
-- 
JCW


"John Spencer" wrote:

> If you are doing this in VBA, you need to put
> 
>     IIf([MultiClassTrigger]=True,[TotalTuitions]*0.1,0)
> 
> into the VBA code.  You should have
>    [Expression]
> in the After Update property and then click the three dots at the end to open 
> the VBA window and put the above statement in the code.
> 
> I would do this slightly different.  I would set the control source of 
> TotalTuitions to the expression.
> =IIf([MultiClassTrigger]=True,[TotalTuitions]*0.1,0)
> 
> And it might be necessary for you to force a recalc of the totalTuitions 
> control when you change the value of the MultiClassTrigger control. If the 
> total tuitions control fails to update try putting the following in the after 
> update event code of the MultiClassTrigger control.
>     Me.TotalTuitions.Requery
> 
> 
> John Spencer
> Access MVP 2002-2005, 2007-2010
> The Hilltop Institute
> University of Maryland Baltimore County
> 
> JohnW wrote:
> > Kevin
> > 
> > When I put in my IIF statement into the afterupdate of the MultiClassTrigger 
> > field it gives me a "The expression you entered contains invalid syntax" "You 
> > may have entered an operand without an operator.
> > 
> > I am using 
> > 
> > MultiClassDisc:IIf([MultiClassTrigger]=Yes,[TotalTuitions]*0.1,0)
> > 
> > Suggestions?  Thanks
> > 
> .
> 
0
Utf
3/26/2010 12:21:01 AM
Are we talking about FIELDS or CONTROLS?

I would not have a MultiClassDisc field in a table since it is dependent on 
other fields.  I assume that MultiClassTrigger is a True/False field.  Is 
TotalTuitions a field in your table or is it a control that is a sum of some 
field values?

If TotalTuitions is a control with a source that looks like:
   =Sum([CourseTuition])
then we need to do things differently than if TotalTuitions is a FIELD in a table.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

JohnW wrote:
> John
> I am not sure if I am following.  I am tryin to use the MultiClassTrigger 
> field to force the calculation of the MultiClassDisc field.  When the Trigger 
> field is clicked to Yes I need it to take TotalTuitions*.1 to calculate the 
> 10% discount.  When it is clicked No I want MultiClassDisc to equal zero.
> 
> Maybe this is what you're trying to do but when I put the code in the after 
> update field nothing is happening.
> 
> I apprecaite your help and patience.
0
John
3/26/2010 3:48:18 PM
John

As I read back thru my posts I realize I probably wasn't clear enough.  I 
have a billing form that was created from a query based on the table that all 
these fields are from.  In this billing query is where all these calculations 
are happening so they can be displayed on the billing form.

TotalTuitions is a field that exists in my main table and it is calculated 
in the billing query by adding (4) other tuition type fields.

MultiClassDisc is a field in my main table and is in the billing query.  
Initially we were not going to calculate this, they were going to just type 
it in.  

MultiClassTrigger is a field in my main table that works from a Yes/No combo 
box.  This will also be in the billing query.

 The SQL view of the billing query is pretty lengthy but here it is......

SELECT ECG.Gymnasts, ECG.BillingName, ECG.BillingAddress, ECG.luBillingCity, 
ECG.BillingState, ECG.luBillingZip, ECG.StartDate, ECG.TodayDate, 
DateDiff("d",[StartDate],[TodayDate]) AS Days, ECG.Hours, ECG.Tuition, 
Switch([Days]>=365 And [Days]<730,0.05,[Days]>=730 And 
[Days]<1095,0.1,[Days]>=1095 And [Days]<1460,0.15,[Days]>=1460 And 
[Days]<1825,0.2,[Days]>=1825 And [Days]<2190,0.25,[Days]>=2190 And 
[Days]<2555,0.3,[Days]>=2555 And [Days]<2920,0.35,[Days]>=2920 And 
[Days]<3285,0.4,[Days]>=3285 And [Days]<3650,0.45,[Days]>=3650 And 
[Days]<4015,0.5,[Days]>4015,0.5,True,1) AS CSP, ECG.MultiClassDisc, 
ECG.MultiChildDisc, ECG.MilitaryDisc, ECG.MiscDisc, 
([TotalTuitions])-[MultiClassDisc]-[MultiChildDisc]-[MilitaryDisc]-[MiscDisc] 
AS MonthlyTotal, ECG.[Late Fee], ECG.BalanceOverDue, 
[MonthlyTotal]+[BalanceOverDue]+[Late Fee]+[MiscPay] AS BalanceDue, 
ECG.Gymnasts2, ECG.Gymnasts3, ECG.Gymnasts3, ECG.StartDate2, ECG.StartDate3, 
ECG.StartDate4, ECG.Tuition2, ECG.Tuition3, ECG.Tuition4, Switch([Days2]>=365 
And [Days2]<730,0.05,[Days2]>=730 And [Days2]<1095,0.1,[Days2]>=1095 And 
[Days2]<1460,0.15,[Days2]>=1460 And [Days2]<1825,0.2,[Days2]>=1825 And 
[Days2]<2190,0.25,[Days2]>=2190 And [Days2]<2555,0.3,[Days2]>=2555 And 
[Days2]<2920,0.35,[Days2]>=2920 And [Days2]<3285,0.4,[Days2]>=3285 And 
[Days2]<3650,0.45,[Days2]>=3650 And [Days2]<4015,0.5,[Days2]>4015,0.5,True,1) 
AS CSP2, Switch([Days3]>=365 And [Days3]<730,0.05,[Days3]>=730 And 
[Days3]<1095,0.1,[Days3]>=1095 And [Days3]<1460,0.15,[Days3]>=1460 And 
[Days3]<1825,0.2,[Days3]>=1825 And [Days3]<2190,0.25,[Days3]>=2190 And 
[Days3]<2555,0.3,[Days3]>=2555 And [Days3]<2920,0.35,[Days3]>=2920 And 
[Days3]<3285,0.4,[Days3]>=3285 And [Days3]<3650,0.45,[Days3]>=3650 And 
[Days3]<4015,0.5,[Days3]>4015,0.5,True,1) AS CSP3, Switch([Days4]>=365 And 
[Days4]<730,0.05,[Days4]>=730 And [Days4]<1095,0.1,[Days4]>=1095 And 
[Days4]<1460,0.15,[Days4]>=1460 And [Days4]<1825,0.2,[Days4]>=1825 And 
[Days4]<2190,0.25,[Days4]>=2190 And [Days4]<2555,0.3,[Days4]>=2555 And 
[Days4]<2920,0.35,[Days4]>=2920 And [Days4]<3285,0.4,[Days4]>=3285 And 
[Days4]<3650,0.45,[Days4]>=3650 And [Days4]<4015,0.5,[Days4]>4015,0.5,True,1) 
AS CSP4, ECG.Hours2, ECG.Hours3, ECG.Hours4, ECG.Gymnasts4, 
DateDiff("d",[StartDate2],[TodayDate]) AS Days2, 
DateDiff("d",[StartDate3],[TodayDate]) AS Days3, 
DateDiff("d",[StartDate4],[TodayDate]) AS Days4, ECG.[Session Payment], 
ECG.BillComments, ECG.InvComments, IIf([CSP]<1,[Tuition]*[CSP],0) AS CSPCalc, 
IIf([CSP2]<1,[Tuition2]*[CSP2],0) AS CSPCalc2, 
IIf([CSP3]<1,[Tuition3]*[CSP3],0) AS CSPCalc3, 
IIf([CSP4]<1,[Tuition4]*[CSP4],0) AS CSPCalc4, 
IIf([Tuition]>0,[Tuition]-[CSPCalc],0) AS TotTuition, 
IIf([Tuition2]>0,[Tuition2]-[CSPCalc2],0) AS TotTuition2, 
IIf([Tuition3]>0,[Tuition3]-[CSPCalc3],0) AS TotTuition3, 
IIf([Tuition4]>0,[Tuition4]-[CSPCalc4],0) AS TotTuition4, ECG.lupClass, 
ECG.MiscPay, ECG.MiscDiscDesc, ECG.StartDateDesc, ECG.MiscPayDesc, ECG.Email, 
ECG.luWaiveLateFee, ECG.MultiClassTrigger, 
([TotTuition]+[TotTuition2]+[TotTuition3]+[TotTuition4]) AS TotalTuitions
FROM ECG
WHERE (((ECG.Gymnasts)=[Forms]![Gymnasts List]![cboGymnasts]) AND 
((ECG.lupActive) Like "*yes*"));


I hope this helps.  Thanks.

-- 
JCW


"John Spencer" wrote:

> Are we talking about FIELDS or CONTROLS?
> 
> I would not have a MultiClassDisc field in a table since it is dependent on 
> other fields.  I assume that MultiClassTrigger is a True/False field.  Is 
> TotalTuitions a field in your table or is it a control that is a sum of some 
> field values?
> 
> If TotalTuitions is a control with a source that looks like:
>    =Sum([CourseTuition])
> then we need to do things differently than if TotalTuitions is a FIELD in a table.
> 
> 
> John Spencer
> Access MVP 2002-2005, 2007-2010
> The Hilltop Institute
> University of Maryland Baltimore County
> 
> JohnW wrote:
> > John
> > I am not sure if I am following.  I am tryin to use the MultiClassTrigger 
> > field to force the calculation of the MultiClassDisc field.  When the Trigger 
> > field is clicked to Yes I need it to take TotalTuitions*.1 to calculate the 
> > 10% discount.  When it is clicked No I want MultiClassDisc to equal zero.
> > 
> > Maybe this is what you're trying to do but when I put the code in the after 
> > update field nothing is happening.
> > 
> > I apprecaite your help and patience.
> .
> 
0
Utf
3/26/2010 5:21:01 PM
Sorry.  I will be offline for the next few days.  You might start a new thread 
and see if someone can help you.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

JohnW wrote:
> John
> 
> As I read back thru my posts I realize I probably wasn't clear enough.  I 
> have a billing form that was created from a query based on the table that all 
> these fields are from.  In this billing query is where all these calculations 
> are happening so they can be displayed on the billing form.
> 
> TotalTuitions is a field that exists in my main table and it is calculated 
> in the billing query by adding (4) other tuition type fields.
> 
> MultiClassDisc is a field in my main table and is in the billing query.  
> Initially we were not going to calculate this, they were going to just type 
> it in.  
> 
> MultiClassTrigger is a field in my main table that works from a Yes/No combo 
> box.  This will also be in the billing query.
> 
>  The SQL view of the billing query is pretty lengthy but here it is......
> 
> SELECT ECG.Gymnasts, ECG.BillingName, ECG.BillingAddress, ECG.luBillingCity, 
> ECG.BillingState, ECG.luBillingZip, ECG.StartDate, ECG.TodayDate, 
> DateDiff("d",[StartDate],[TodayDate]) AS Days, ECG.Hours, ECG.Tuition, 
> Switch([Days]>=365 And [Days]<730,0.05,[Days]>=730 And 
> [Days]<1095,0.1,[Days]>=1095 And [Days]<1460,0.15,[Days]>=1460 And 
> [Days]<1825,0.2,[Days]>=1825 And [Days]<2190,0.25,[Days]>=2190 And 
> [Days]<2555,0.3,[Days]>=2555 And [Days]<2920,0.35,[Days]>=2920 And 
> [Days]<3285,0.4,[Days]>=3285 And [Days]<3650,0.45,[Days]>=3650 And 
> [Days]<4015,0.5,[Days]>4015,0.5,True,1) AS CSP, ECG.MultiClassDisc, 
> ECG.MultiChildDisc, ECG.MilitaryDisc, ECG.MiscDisc, 
> ([TotalTuitions])-[MultiClassDisc]-[MultiChildDisc]-[MilitaryDisc]-[MiscDisc] 
> AS MonthlyTotal, ECG.[Late Fee], ECG.BalanceOverDue, 
> [MonthlyTotal]+[BalanceOverDue]+[Late Fee]+[MiscPay] AS BalanceDue, 
> ECG.Gymnasts2, ECG.Gymnasts3, ECG.Gymnasts3, ECG.StartDate2, ECG.StartDate3, 
> ECG.StartDate4, ECG.Tuition2, ECG.Tuition3, ECG.Tuition4, Switch([Days2]>=365 
> And [Days2]<730,0.05,[Days2]>=730 And [Days2]<1095,0.1,[Days2]>=1095 And 
> [Days2]<1460,0.15,[Days2]>=1460 And [Days2]<1825,0.2,[Days2]>=1825 And 
> [Days2]<2190,0.25,[Days2]>=2190 And [Days2]<2555,0.3,[Days2]>=2555 And 
> [Days2]<2920,0.35,[Days2]>=2920 And [Days2]<3285,0.4,[Days2]>=3285 And 
> [Days2]<3650,0.45,[Days2]>=3650 And [Days2]<4015,0.5,[Days2]>4015,0.5,True,1) 
> AS CSP2, Switch([Days3]>=365 And [Days3]<730,0.05,[Days3]>=730 And 
> [Days3]<1095,0.1,[Days3]>=1095 And [Days3]<1460,0.15,[Days3]>=1460 And 
> [Days3]<1825,0.2,[Days3]>=1825 And [Days3]<2190,0.25,[Days3]>=2190 And 
> [Days3]<2555,0.3,[Days3]>=2555 And [Days3]<2920,0.35,[Days3]>=2920 And 
> [Days3]<3285,0.4,[Days3]>=3285 And [Days3]<3650,0.45,[Days3]>=3650 And 
> [Days3]<4015,0.5,[Days3]>4015,0.5,True,1) AS CSP3, Switch([Days4]>=365 And 
> [Days4]<730,0.05,[Days4]>=730 And [Days4]<1095,0.1,[Days4]>=1095 And 
> [Days4]<1460,0.15,[Days4]>=1460 And [Days4]<1825,0.2,[Days4]>=1825 And 
> [Days4]<2190,0.25,[Days4]>=2190 And [Days4]<2555,0.3,[Days4]>=2555 And 
> [Days4]<2920,0.35,[Days4]>=2920 And [Days4]<3285,0.4,[Days4]>=3285 And 
> [Days4]<3650,0.45,[Days4]>=3650 And [Days4]<4015,0.5,[Days4]>4015,0.5,True,1) 
> AS CSP4, ECG.Hours2, ECG.Hours3, ECG.Hours4, ECG.Gymnasts4, 
> DateDiff("d",[StartDate2],[TodayDate]) AS Days2, 
> DateDiff("d",[StartDate3],[TodayDate]) AS Days3, 
> DateDiff("d",[StartDate4],[TodayDate]) AS Days4, ECG.[Session Payment], 
> ECG.BillComments, ECG.InvComments, IIf([CSP]<1,[Tuition]*[CSP],0) AS CSPCalc, 
> IIf([CSP2]<1,[Tuition2]*[CSP2],0) AS CSPCalc2, 
> IIf([CSP3]<1,[Tuition3]*[CSP3],0) AS CSPCalc3, 
> IIf([CSP4]<1,[Tuition4]*[CSP4],0) AS CSPCalc4, 
> IIf([Tuition]>0,[Tuition]-[CSPCalc],0) AS TotTuition, 
> IIf([Tuition2]>0,[Tuition2]-[CSPCalc2],0) AS TotTuition2, 
> IIf([Tuition3]>0,[Tuition3]-[CSPCalc3],0) AS TotTuition3, 
> IIf([Tuition4]>0,[Tuition4]-[CSPCalc4],0) AS TotTuition4, ECG.lupClass, 
> ECG.MiscPay, ECG.MiscDiscDesc, ECG.StartDateDesc, ECG.MiscPayDesc, ECG.Email, 
> ECG.luWaiveLateFee, ECG.MultiClassTrigger, 
> ([TotTuition]+[TotTuition2]+[TotTuition3]+[TotTuition4]) AS TotalTuitions
> FROM ECG
> WHERE (((ECG.Gymnasts)=[Forms]![Gymnasts List]![cboGymnasts]) AND 
> ((ECG.lupActive) Like "*yes*"));
> 
> 
> I hope this helps.  Thanks.
> 
0
John
3/30/2010 11:53:12 AM
Reply:

Similar Artilces:

Global Fields in SQL tables
Does anyone know where do I find the global fields that are available in Report writer in what SQL database table? I need to know cause I need some of the global found in the Report Writer to insert them into a crystal report. Thanks in advance That depends on what field you are looking for. Which fields do you need? "ec" wrote: > Does anyone know where do I find the global fields that are available in > Report writer in what SQL database table? I need to know cause I need some of > the global found in the Report Writer to insert them into a crystal report. > &g...

Using wildcards w/ sumproduct
I'm not familiar with wildcards in formulas, and I can't seem to figure out exactly what to do here. If the first 3 letters in cells of column A contain FPC, then sum corresponding rows in column P, then by the total number of cells in column AT where the first 3 letters are FPC. =SUMPRODUCT((LEFT(A1:A20014,3*(closed!$A$3:$A$20003="FPC"))),(closed!$P$3:$P$20003)/SUMPRODUCT((LEFT(A1:A20014,3*(closed!$AT$3:$AT$20003="FPC"))))) Any assistance is greatly appreciated. Thanx, ~Julz Hi if I understood you correctly try =SUMPRODUCT(--(LEFT(closed!$A$3:$A$20003)=&qu...

Outlook using RPC over HTTP and Passwords
We have implemented mandatory password changes every 60 days and the remote users with Outlook over http and not given an opportunity to change the password when it expires. After the 60 days they can't get in and I need to change their password on the server. Is there something I need to do? or fix? VPN users are being prompted to change their passwords and can change them themselves. -- Regards Chris Can they change them from OWA? -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/...

GP 10 Upgrade error eone excelbuilder gpaddin threw an exception
I ran my live GP10 install tonight. Everything on the server ran fine but when I tried updating my own pc, install runs, I can launch Utilities, but when I try to log in I get this error message: "eOne.Dynamics.GP.ExcelBuilder.Engine.dll: Exception has been thrown by the target of an invocation. InnerException: The type initializer for eOne.Dynamics.GP.ExcelBuilder.GPAddIn threw an exception." My pc is XP Pro, SP3 with Office 2007. Any ideas on how to get past this? Thanks, DavidF. I figured out the problem. One of my modified dictionaries didn't upgrade. I reran utili...

How can I find out which apps are using .NET and which not?
I appear to have three versions of .NET (2, 3, 3.5) with their associated special packs. How can I find out which apps are using .NET. (Please, no 'cut-one-out' method, I do not want to uninstall and see what has stopped working.) I am aware that the different .NETS are individually and separately usable by different apps - my questions is what app uses which? Thanks for any pointers occam wrote: > I appear to have three versions of .NET (2, 3, 3.5) with their > associated special packs. > > How can I find out which apps are using .NET. (Please, no 'c...

Using the Google Calendar .net API from an Access application
I have a scheduling/calendar application in access. I also use Goggle calendar. Would it be possible to use .net from Access to send my schedular entries to my Goggle calendar? OP <OP@discussions.microsoft.com> wrote: >I have a scheduling/calendar application in access. I also use Goggle >calendar. Would it be possible to use .net from Access to send my schedular >entries to my Goggle calendar? It might be possible but you'd have to do a lot of digging through the Google calendar documentation looking for the various APIs and figuring out how to execu...

Field Service Non-Inventory Parts
Ability to use non-inventory parts in the parts section of field service. Most parts we use for repair are non-stocking parts. Be useful to have the ability so you can track and transfer field service parts the same way you do regular parts. That way when you do a tranfer pick list to a service truck you can make sure you have a full list of needed parts, instead of a generated one for inventory parts, and some manual made up one for parts you don't stock ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To v...

FWD: Use pack
--nozugocqswhapz Content-Type: multipart/related; boundary="ocmbostjnqamcd"; type="multipart/alternative" --ocmbostjnqamcd Content-Type: multipart/alternative; boundary="wtcazseafbqr" --wtcazseafbqr Content-Type: text/plain Content-Transfer-Encoding: quoted-printable MS Customer this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to prote...

Automatic Calculation on only one Worksheet
Is it possible to have one worksheet in a Workbook calulate manually while all others automatically? The reason I would like this is I have a sheet which pulls in real-time market data that slows down my Workbook if calculation is on automatic for the workbook. If I turn off automatic calculation for the workbook then I end up spending a lot of time hitting F9 or shift + F9. Thanks No. But I do think you can with two instances of Excel. Just start another Excel -- Kind regards, Niek Otten "sfrancoe2" <sfrancoe2@discussions.microsoft.com> wrote in message news:CF6DE...

Using a form instead of a parameter query.
We are using Access 2007. There are several parameters that my db users have to input to "filter" the data that will complete reports for the agency. I have no trouble using date fields on a form that allows the user to define the date range. However, the users need to specify foreign key fields (long int.) and I wish them to enter more than one value in the field at one time. Using the In () operator works fine on the query itself, but how can I have the users type several integers in a text box on a form that will form the parameter for the query? Any ideas? And than...

Is there a Print Preview without using the Preview app?
Is there a way to see what a document will look like on a printed page while working within Office? I know I can do Print>Preview, but that views the document in Preview, not in Office. "Office" is a suite of applications programs - knowing which of those programs you're referring to would make it a bit easier to answer your question:) In general, however, Office never has done the printing & the current Apple guidelines for printing allow for the apps to no longer have to provide a preview service which was [and is] generated by the OS & printer driver in the first ...

Combining fields into one
Hi all, I'm busy with an assett database to record all IT eqioment. I now have the following problem.. I have aa field called "speed" in which I type the speen of the CPU ie "2.4GHz" I'm a bit too lazy to type it 120 times so I created a table for it and think I have gone too difficult for myself. I wound up creating teo tables, one for the speed (called speed with speedid and speed and clockid) and another called clock (with clockid and clock) In speed I would only type the number and then have a drop down that looks up if it is KHz, MHz or GHZ from the cl...

SQL Question and Form Field Displays
Can some one please give me a bit of advice on how to accomplish the following: I have two tables (called Questions and Answers). The Questions table has five records, each with a unique question_Number field (from 1 - 5). I have created a query that pulls in all five Question records based on their primary key field and I am able to sequentially display all five records in my form. The Answers table has a single record that is associated with the records on the Question table by referencing the primary key field. The Problem: 1. I want the single Answer record to appear with each indivi...

Country, Phone and email showing inthe Bill to or Ship To fields
When we set a customer in Store Operations POS we need to verify some extra information in the Bill to and Ship to windows for shipping purposes. Is there a way to display the Country, Phone number and the email address in these windows? At the very least we need to be able to see the country. Had a similar issue a few months ago where I needed to see customer email, phone, available balance, and account number - but the white boxes "bill to" and "ship to" aren't editable, so I got assistance on this newsgroup (think it was Jerry Data - thanks Jerry) on editing...

Corrupt emails when using multipart content types
I am running Exchange 2003 with latest SPs and am running into a very strange problem. When we receive certain emails, the contents of the messages have been corrupted. Exclamation points (!) seem to appear randomly in the text (usually an exclamation point followed by a space). The messages both contain HTML and TEXT content, the header is: Content-Type: multipart/alternative; boundary="----=_NextPart_000_365D_01C59758.21CA9D10" The text version content type is: ------=_NextPart_000_365D_01C59758.21CA9D10 Content-Type: text/plain; charset="iso-8859-1" Content-Tr...

Problem with TOC using various TOC styles in the same table (Wrd20
Hello, I'm having a weird problem with the table of contents. I have been editing a long document and am regularly updating the TOC. I have just noticed that the spaces between the lines were various in the TOC and thus used the style inspector to find out why. It appeared that TOC 1, TOC 2, TOC 3, TOC 4...styles were all there in the TOC. I have no idea why, I'm creating the TOC repeatedly, removing or replacing the previous one and when creating, I'm choosing TOC 1 as the style but when the TOC is inserted, the problem is the same. Single space here, 1.5 space th...

How can I make a sheet display data from another sheet based on date criteria?
Hello, Say I have an Excel workbook with 3 sheets (sheet1, sheet2, sheet3). Each sheet has two columns (Date, Thing that happened on that date). I would like to know if there's a way to have a fourth sheet, called "on this date in history" (or whatever). It would consider today's date and display each thing that happened on todays date in previous years on each row. So basically, if I open the workbook on May 11th, 2007 and go to the fourth sheet, it would show me a list list of events that happened on May 11th in previous years, and it would update for each day that I vi...

vista 08-05-10
Dit is een meerdelig bericht in de MIME-indeling. ------=_NextPart_000_0038_01CB34CD.CECFDC60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hallo allemaal, In mijn postvak uit heb ik 3 berichten die "vast" blijven zitten en=20 verwijderd kunnen worden, hierdoor kan ik geen mail meer versturen, = deze 3=20 berichten blokkeren het gehele stysteem. Hoe kan ik dit probleem verhelpen?? Ik heb windows vista!!!!!!!!! Met vriendelijke groet, Harry=20 ------=_NextPart_000_0038_01CB34CD.CECFDC60 Content-Typ...

I need a formula to calculate 2-3 columns but skip a column if it has a zero
I'm building a Golf League spreadsheet and we want to calculate handicaps starting with the second week (calculates 2 weeks) and then after the 3rd week calculates every 3 weeks. Columns B-S are the individual weeks scores for each golfer (golfers listed by row 4-33), each column (b-s) has a formula which pulls the golfers score from the input worksheet(weekly input) to this worksheet(scorecard). Starting with Column V we are trying to have the running handicap for the year which changes each week. Column W is the first week handicap =AVERAGE(B4-36)*0.8 (this ones easy) Column X is the se...

how do I add another hotmail email inbox in Outlook?
Hello, I added my main hotmail address in Outlook, and that works fine. However, I then added a buisness hotmaill address (another hotmail address) in Outlook, but this time an error message appears when trying to access my inbox saying error 0x800CCCF6 Access to Hotmail via Outlook and Outlook Express now requires a subscription. Why does that do that only 2mn after having added the other hotmail address uneventfully? Please reply soon! Thank you! did you previously access the other account using http? As of last sept, http access was ended for new accounts. http://www.slipstick.com/ad...

How to create multiple subfolders using VBA
Hello and thanks for reading my question. I need some VBA programming help. I have a main folder with subfolders in it. I want to add a new subfolder to each subfolder in the directory. It would look something like this Main Folder Subfolder1 NewSubfolder Subfolder2 NewSubfolder Subfolder3 NewSubfolder Subfolder4 NewSubfolder I was able to use this VBA to do it for one folder, but I need it to look through all Subfolders MkDir ("C:\MainFolder\Subfolder1\Subfolder1.1") How do I look through each subfolder and add a new subfolder under each...

Time zone issue with calendar invites sent to iCal users 03-09-10
We're using Entourage 2008 (latest patch) in conjunction with Exchange 2003. We're on the West Coast in the U.S. When we send calendar invites to one of our employees in Zurich who uses iCal, they always show the wrong time, e.g., an invitation for 9am PST will show up in his calendar at 9am Zurich time rather than being automatically adjusted for the time difference. I've seen postings about this issue but have not seen a resolution. Any suggestions? (All users are on Intel Macs running OS X 10.5.8.) Many thanks. ...

calculating time/dates differences
I'm looking for a formula that will allow me to calculate the difference between the time and date of one day and the next. I also need to be able subtract out the time between 17:00 ahd 08:30 as well as weekend days and holidays. Example 6 June 16:51 to 7 June 9:51 Here's some formulas and information that might help: http://www.officearticles.com/excel/date_formulas_and_functions_in_microsoft_excel.htm The most important part is the formatting of the cell that contains the formula. Also, when you subtract dates/time, the answer is provided in DAYS. So if you want the number of...

Report creation in Excel Using VB.Net App.
Hello All, We're just looking into options for creating report output for our application. We've used Crystal before and found limitations, so have taken to writing reports direclty into MS Excel, (add in DLL, and create sheet and data via direct code) and it appears to be working just fine so far. I was just curious if anyone else has taken this approach and if it's worked well for them. Thanks & all the best, Ed. ...

field service allow setup of cycle charge allowed up to
Field service needs to allow the setup in meter readings to have an amount for each meter reading that is not charged versus just a maximum in the base field. For instance the customer each meter reading gets the first 1000 cycles at no charge and .05 per cycle over the allowance. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsre...