Search results

I'm trying to understand this formula. To be exact I'm trying to make this formula work for rolling months I see that the DateAdd is looking back 6 months and the and Date()) is looking at today’s date. I need to be able to change this formula so I'm able to pull that date for January/ 13th...

I’m trying to find all the “9” in the ([OMNI_Status1]) that fall between the last full month to the past 3 months 02/01/11 4 < - Found 4 9’s 01/11/11 1 <- Found 4 9 12/25/10 2 <- Found 2 9’s 11/14/10 8 <- found 8 9’s Please let me know if I can provide any additional information Thanks...

I'm working on a iif and statement that will turn the numbers in my ([OMNI_Status1]) from "9" to a 1, and if it’s not a "9" make it a "0" I will also need to Trim the ([OMNI_Status1]) field Below is what I thought would work but its either telling me that I have then wrong number of arguments...

Thanks AUguy, With the formula you provide I was able to work. Thanks again for your help TCB

Thank you Guy, I tried your formula and this is the data I'm getting? I'm not sure what I need to change to correct it JanTest -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 -1 I want access to look in this field ([CORRESPONDENT_PURCHASE_DATE] and have it just pull the dates for January 1st to...

Hi everyone again. I’m working on making my database roll with each month that changes. Below is what I have so far, and was hoping someone could help me with the rest. The error message I’m getting is: The expression you entered has a function containing the wrong number of arguments...

Changed settings In VBE: Tools Options General (Tab) set to "Break on unhandled errors" Then used this code, Public Function getSTDev(ParamArray varVals() As Variant) As Variant Dim varVal As Variant Dim intcount As Integer Dim Arr() As Variant For Each varVal In...

vbaInet, /MSAccessRookie /lagbolt, I was able to get the VBA code to work!!!! Thank you all so much for staying with my and helping me get this code to work. This is awesome. I hope you all know how much you’ve help me and everyone else that needs help in this form, you guys ROCK!!!. Thank...

Thanks lagbolt, I agree with you 100%, and when I get these database working, I'm going to take some time to learn about Normalization. Thank you for taking the time to recommend the steps I need to take

This is the Database I'm using to test my Standard Deviations. hope this helps http://www.4shared.com/document/wRQ9pYOC/TestingSD.html?

Thanks guys, what information can I provide to help, and how do I do a row-wise StDev() ?

Thanks lagbolt can you help me understand why am I not able to get this to run? SELECT OMNI#, May_Pull_Thru, June_Pull_Thru, July_Pull_Thru, Aug_Pull_Thru, Sept_Pull_Thru, Oct_Pull_Thru, StDev(Amount) AS StDevOfAmount FROM Master_Join_tbl GROUP BY SomeField; Thank you

I’m trying to get the Standard Deviations but in order for me to do this I need to skip over months that have a “false” or “zero” in the cell. I’m using a VBA Script to get my Standard Deviation, but if there is a better way, please let me know that also. The script I’m using takes 6 months...

thanks Guys, I will try that

I’m trying to run a query from within a query "But Run it Last". Basically I’m wondering if I can run a query or sql in a order so that all filters and formulas in a query will run, but before it’s finished it will look at the last formula This is the statement I would like to run at the...

sorry. wont happend again

I’m trying to rank against my standard deviation which looks like this standard deviation: 0.125 The formula I’m using is this: [code] SDRank: 1+DCount("*","[Tablename]","[ standard_deviation]<" & [standard_deviation]) but the only number that comes back is “1” I have over a hundered reps...

I’m hoping someone can help me with my newest rank issue. I’m trying to get a rank my standard deviation so it will be a number below 1, the numbers I'm trying to rank are below Example: Rank1: 1+DCount("*","[Table1]","[Standers deviation]<" & [Standers deviation]) In addition, my rank comes...

Thanks vbaInet, that worked perfect

Hi vbaInet, I wasn’t quit sure what it is called but I have a list of reps that I'm using a Rank formula that ranks my reps buy the number of apps they get. So now that I have their rank, I would like to put them in a scale from 1-5 with one being the best. In excel the formula looks...