Search results for query: *

Thank you Combo, I got a solution for my issue. I use 2016 though. I will add PowerQuery here, I have it at home. :D Patty

No it is not. :)

LOL!!! Like is said...staring right at me. Thank you!! It was my ranges, in all the back and forth checking and rechecking, I confused my AssetSpec with my DataCost and changed the reference cells in both. It works now.

Thank you Skip. I can't get it to work, after checking all the data, the ranges, and putting the formula in the data sheet, still no good. UGH! Makes no sense to me, I'm sure the problem is staring me in the face, it usually does.

Yes, I verified all costs are Numbers, currency actually and all AssetSpec cells are text. No change. Thank you!

Hi Skip, Asset Spec is in column G "G10:G28025" on sheet A_LCCP. I did change my name and used your name "DataCost" for the $ columns R-AY, no Column G is not included in the DataCost="R10:AY28025" range. =SUMPRODUCT((AssetSpec=$A7)*(DataCost))

It's not even the true values, why would a #Value error occur when looking at text data? This is the part that gets all the errors, randomly. (A_LCCP!$G$10:$G$28025=$A7) I did name the range, I just changed it to check for errors in the saving of the range. Which equals your (AssetSpec=$M5)

I'm getting a #VALUE error for every True instance :( Thank you for your help.

Hello combo and SkipVought, I will include a stripped down version of my data for your more detailed recommendations. I believe my match needs another or several more match statements. Thank...

Hello, Can anyone please let me know what I am missing in my formula? This is the formula that I have: =SUM(INDEX(A_LCCP!$A$10:$A$28046,MATCH($A7,AssetSpec,0)):INDEX(A_LCCP!$AY$10:$AY$28046,MATCH($A7,AssetSpec,0))) It works BUT! I need the sum of multiple columns. The value of A7 is in many...

I was given this formula in another forum and works beautifully! =IF(COUNT($H12:$AA12)>1,(SUM($H12:$AA12)-MIN($H12:$AA12))/(COUNT($H12:$AA12)-1),IF(COUNT($H12:$AA12)=1,SUM($H12:$AA12),"")) [elephant2]

So is there a way to direct the ELSE value to the only value in the range?

Here is my formula: =IF(COUNT($H5:$AA5)>1,(SUM($H5:$AA5)-MIN($H5:$AA5))/(COUNT($H5:$AA5)-1),"") The problem is that it removes a value when it is the only value in the row. Can anyone suggest perhaps a different formula? My goal is to find the "pessimistic avg" and the "optimistic avg"...

There was no filter turned on. All filters turn on when GotFocus. Adding ActiveFilter in If statement fixed the problem. Private Sub cmdPreviewFilteredReport_Click() Dim subFormFilter As String Dim ActiveFilter As Boolean subFormFilter = Me.frmLianzi_MDR_Form_Updates.Form.Filter...

Hello, I realized a problem with this code. It seems that upon first opening the database, the first time the command button is clicked, no filter applied, the OpenReport defaults to the InProcess filter, yet the form itself is showing unfiltered (All) records. After it is clicked a second time...

Thanks, I inserted the preview and had the query [Delegated Owner] filter on the combobox of main form. Works perfect. Private Sub cmdPreviewFilteredReport_Click() Dim subFormFilter As String subFormFilter = Me.frmLianzi_MDR_Form_Updates.Form.Filter If subFormFilter = "" Then...

Not sure how, but it tried to -->print<-- a boat load of pages, where it should have been 2. Private Sub cmdPreviewFilteredReport_Click() Dim subFormFilter As String subFormFilter = Me.frmLianzi_MDR_Form_Updates.Form.Filter If subFormFilter = "" Then DoCmd.OpenReport...

Here is the toggle code for all five buttons, they work fine: Private Sub tglAllRecords_GotFocus() With Me!frmLianzi_MDR_Form_Updates.Form .FilterOn = False .Filter = "" End With End Sub Private Sub tglCompleted_GotFocus() With Me!frmLianzi_MDR_Form_Updates.Form .Filter = "Progress...

Hello, Help with some code would be greatly appreciated. I have a form with a subform. On my main form I have a combobox that allows the user to choose a delegated owner. The subform then displays all the delegated owners’ records. There is also an options frame with five toggle button filter...