updating through a loop statement
I'm using a loop to update a table dynamically, meaning that only certain
fields will be updated each time the stored procedure that contains the loop.
I have noticed that it's taking a lot of time. I have a feeling that it's
sending the various update statements to the sql server as quickly as it goes
through the loop.
Is there a way to pause the loop until each update statement is finished
processing? I should add the the update statement is executed via
sp_executesql as I have to build the statement with various variables.
Hope this made sense
scuba79 (sc...Money 2001
I have recently moved to Papua New Guinea and have set up my local accounts
on Money 2001. I have added the local currency - PGK kina to the currencies
but when I try to download my bank statements I get this error box message:
Your file import was completed, but 1 item could not be processed...
X Your statement contained a default currency (PGK) which was unrelated to
the currency of the account "Westpac PNG Cheque". Money does not support
statements containing unrelated default currencies.
I was dowloading the file in OFX format. QIF files work...If statement..... Possible Match
I'm trying to make two fields that are similar.
I create but it won't give me the result.
FieldA : Baseball
Possible Match: Yes
Possible Match: Yes
Possible Match: NO
Please help me if I did the right or not. Your help would be much
Possible Match: IIF([FieldA] like [FieldB],"Yes","NO")
>I'm trying to make two fields that are similar.
>I create but it won't g...If/then statement between dates
Hello. I am trying to draft an if/then statement that will pull a
rate from a table and use it to multiply by a number from a different
Field: Date of Expense
I am trying to add into my form (ExpensesAll) a string to an unbound
text box that will multiply the mileage by the mileage rate that was
effective on the date of the expense. There are several different
rates corresponding to their respective start dates in the MileageRate
An...If statements #3
worked perfectly thanks alo
Brad1982's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1569
View this thread: http://www.excelforum.com/showthread.php?threadid=27255
...If statements #2
I have this formula which works 99% of the time, only in the last
instance do I get it to fail when I add if T<>""),"".
What I'm trying to do is create a formula so that the user ...If
I have a code that is not processing correctly. Can someone look at it to
see what I am missing. I have never done this kind of statement before.
Private Sub CmdSearch_Click()
Dim stDocNameSearch As String
Dim VarSo As Variant
Dim VarRMA As Variant
Dim VarAccNum As Variant
Dim VarPart As Variant
Dim VarSN As Variant
Dim VarLot As Variant
VarSo = Me!CmboSO
VarRMA = Me!CmboRMA
VarAccNum = Me!CmboAccNum
VarPart = Me!CmboPart
VarSN = Me!CmboSN
VarLot = Me!CmboLot
stDocNameSO = "RMARequestSO"
stDocNameRMA = "RMARequestRMA"
stDocNameAccNum = "RMARequestAccNum"
Provide the ability to print statements, in both Store Operations and
Headquarters, by account number, account name (alphabetically), and/or by
Currently, statements print in an indeterminate order that cannot be easily
matched with an account list or any other know filter.
When my printer jams i get to reprint all the statements
over again... a process that takes several hours...
I get to employ 2 people full time to sort the statements
on billing day...
In the old, Quicksell days, before microsoft's buy out i
could print in any order, in blocks, and restart t...Deadlock on SQL SELECT statement
I have inherited the maintenance of a product which includes the snipet
of code below. Every 10 seconds the code is executed. It is causing a
deadlock in some instances, but I am undable to reproduce the problem
on my machine. The "PC" table contains a list of PCs seen on a
network, so isn't very large. Since I dont have much background in
database programming, I was wondering if there is some simple answer to
the deadlock issue...but from reading on deadlocks, there rarely seems
to be a simple solution.
// Find PCs to restart
CStri...Statement download problems
OK I figured out how to save my file and then import it.
But I'd still like to simply open the file from my bank
and have my file updated without having to first save it
to my computer.
Open IE click the tools menu and choose options - on the advanced tab scroll
down to security - find the option for - do not save encrypted files to
disk - change this option from what you have - this controls that behavior.
"David E" <firstname.lastname@example.org> wrote in message
> OK I figured out how to save my file an...nested if statements
Not sure if anyone can help me with this
I have 2 sets of criteria.. and I'd like a formula that checks 2 cells
and then calculates a result based on the criteria of those 2 cells.
i'll try my best to explain.
Sales: $50,001 - $75,000
Cell B4 is where the sales number will be entered
Cell B5 will be where the GP is entered
What I want is to have a formula that says
If Sales are between 50,001-75,000 or if GP is btween 20k - 24,999,
then take 3% of GP.
or if Sales are 75k+ or GP is 25k+ then take 4% of GP.
Not sure if anyone can help me with this. I tried using ...If Statement 01-13-10
Need help with this formula?
Need to calculate a formula for CELL A based upon the following
IF CELL B = STOCK and CELL C >= 1.0, <25.0 THAN CELL D * 4
> Need help with this formula?
> Need to calculate a formula for CELL A based upon the following
> IF CELL B = STOCK and CELL C >= 1.0, <25.0 THAN CELL D * 4
=IF(AND(B1="STOCK",C1>=1,C1<25),D1*4,"**No idea what you want here**")
IF( AND( logical1, logical2, logical3 ), value_if_true, **value_if_false** )
Put this in A1:
=3DIF(AND(B1=3D"Stock",C1>=3D1,C1<...SQL select statement question
Hi Everybody -
I am trying to write a SQL query where I can select all vendors except one
particular one - How do I write this? Is there some kind of 'except' command ?
WHERE VENDORID <> 'yourexcludedvendor'
Hope this helps,
MCP-GP, MCT, MVP
East Coast Dynamics
And if you decide you want to exclude more then one use the NOT IN
WHERE VENDORID NOT IN ( 'yourexcludedvendor1', 'yourexcludedvendor2',
'yourexcludedvendor....Financial Statements as My Reports on Home Page
We recently upgraded to GP 9.0 and I would like to add some financial
statements written with Advanced Financial to "My Reports" section. I have
security clearance for everything in GP but none of the financial statements
appear in my report list when I veiw all reports or financial reports. Am I
doing something incorrectly? How can I add financial staterments to the "My
Reports" section of my GP 9.0 home page?
Thanks for your help.
I don't believe the functionality works for AFA.
"Don Johnson" wrote:
> We recently upgraded to GP 9.0 and I would li...Vendor statement of account #3
I need to make a Vendor statement of account like the one for customer (also
multicurrency). I thank you in anticipation.
...Place If-Statement in Macro?
I'd like to automatically copy this If-Statement into a cell using a macro.
Thanks for your help.
There are far better ways to accomplish what you're trying to do, but
this will work:
Public Sub EnterLongFormula()
Selection.Formula = "=IF(OR(C1=""05"&q...Web Statements versus Direct Statements in online services
New to Money 2004. I have a checking account that for some reason is set up
for online services as a "Web Statement". In order to get statements I have
to go to my bank's web site and download manually.
All of my other accounts are set up to download every time I launch Money,
and is labeled as "Direct Statements" on the online services list of
I can't seem to figure out how to switch the settings on this one checking
account to automatically download.
Any help is appreciated
You cannot switch that setting yourself.
The web statements vs. direct s...If-Then Statement #2
How do I do the 50-70 pound part?
alanf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1536
View this thread: http://www.excelforum.com/showthread.php?threadid=26983
...Access 2003 multiple if then statement help
I am having a problem constructing the proper clause for querying my
database. I have multiple values used in computing daily averages of
constituent data for measurements. An example of my table for my table
[tbl_data] is shown below;
Constit Value AdjConstitValue UseIterpolated DoNotUse
S1 1300 1258
[x] [ ]
[ ] [ ]
[ ] [x]
Using an if statement I put together a statement for the query to
display the AdjConstitValue if UseInterpolated is checked and that
works f...More efficient code for multiple If...End If statements
In the on current event of my form, I'm setting the Backstyle and
Borderstyle of several controls based on the whether the control is
' 0 = Transparent
' 1 = Normal
If IsNull(Me.FirstName) Then
Me.FirstName.BackStyle = 0 ' Transparent
Me.FirstName.BorderStyle = 1
Me.FirstName.BackStyle = 1 ' Normal
Me.FirstName.BorderStyle = 1
If IsNull(Me.LastName) Then
Me.LastName.BackStyle = 0 ' Transparent
Me.LastName.BorderStyle = 1
Me.LastName.BackStyle = 1 ' Normal
Me.LastName.Border...Adding With If Statements
I need some assistance please. I have dollar amounts in column C and "Y" or
"N" in column D. I need to add all dollar amounts in column C that have a "Y"
in column D. I know it requires an "IF" statement, but I can not figure it
out and neither can my friends.
Thank you very much
...Another IF statement
I have a minimum order quantity that must be maintained.
Content of cell A1 will vary, B1 will be constant (90) and C1 will be the
C1 has a minimum order charge of 180 applied to it so:
C1 needs to show 0 when A1 is 0
C1 needs to show 180 when A1 is 1
C1 needs to show variable of A1 x B1 above 180
I hope this is clear.
Try in C1: =IF(A1=0,0,MAX(A1*B1,180))
Downloads:21,000 Files:365 Subscribers:65
"Dave in Ampthill" wrote:
> I have a minimum order quantity that must be ...How do I use a wildcard in an if statement?
I want to use a conditional statement to see if a particular cell has a
specific text within a cell. For example:
I want to know if cell A1 contains the text "bag" even though it actually
contains "Large BAG 3".
I want this to work but it does not:
It should return "yes" since bag is within the cell.
You could use:
But keep in mind that FIND is case sensitive.
You could also use:
=IF(ISERROR((SEARCH("*Bag*&qu...IIF statement, proper formula
Not entirely sure if the IIF statement is the correct way to go about this, I
have a field on a query that has total pounds of either printed or plain
product. I want to add a column to my query that only adds up the printed
So, if "product type" is like printed, then add up a total, is basically what
trying to say.
Can you help me with the proper formula?
Message posted via http://www.accessmonster.com
Assuming you have:
- a Text field named product type
- a Number field named pounds
put a text box in the Report Footer section, and set its Contro...Excel Template 9
We need to link the running balance on this template to a aging summary with
customer balance currently due. Are there any compatible templates such as
A/R Summary based on the balances in the Statement of Account template?
[Company Name] Statement Date: 2/23/2010
[Company Address] Date Due: [DATE DUE]
[City, ST ZIP Code]
STATEMENT OF ACCOUNT
[City, State ZIP Code]
DATE DESCRIPTION CHARGES CREDITS ACCOUNT BALANCE
Balance brought forward $56.00
05/12/04 The Phone Company $500.00 ...