Search results for query: *

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

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"...

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

Hi, I have an option group with four toggle buttons on my main form. I'm using them to filter the subform records. I'm sure there is a way to condense the code but I think it works fine. However when I click into the subform to scroll the records the LostFocus clears the applied filter. Any...

Hi, Can someone please tell me the code for a command button(on main form) to filter a subform(query based), Progress field for the number 100? Access 2010 TYIA, Patty [ponytails]

Hello, Can someone give me the exact code for the On Click event for my command button? I have a... Main form: frmDelegatedOwner Subform: frmMDRFilteredsub Command Button: cmdFilterOn Unbound Combobox: cboDelegatedOwner I need the records in the subform filtered, when the button is clicked...

Just wanted to thank GoinDeep for the great post (archived), it's the only one that helped me. Was trying to get the correct code to update (by entering data in separate form) a multicolumn combobox and to requery while suppressing the default error message, displayed my own. thread702-863249...

Need some help... This is the statement I have been trying, Can't get it to work no matter what I change. I am using it in a field on a report: =IIf([OL_TAX_SW]=0,"Y","N") ...all I am trying to do is show a Y for yes or an N for no...where there are 0 (zero's) and 1's. Thanks, pooh

I have searched and searched and nothing currently posted is helping me with my issue. All I need is a count on the number of records from one query for an update query. Here is the statement as it stands: INSERT INTO [SERIAL NUMBERS] ( GE_SERIAL_NUMBER, ETF_SERIAL_NUMBER, ETF_HEAT_CODE...

I am working on an Excel form. Certain cells in the form must be typed (real-time) in Caps and other cells do not need special formatting. I would like to use code to achieve this. I have read a few posts with code that is supposed to change text to caps, but I cannot get any of them to work...

I posted this earlier in the week on the Access Reports Forum. ----------------------------------------------- Hello all, I am having a wonderful time trying to find the solution to my problem. I have looked and looked and every solution to fiscal year problems, don't apply to my...

Hello all, I am having a wonderful time trying to find the solution to my problem. I have looked and looked and every solution to fiscal year problems, don't apply to my particular issue. Please help. I have created a simple report to show all the work orders completed between certain dates...