I am trying to come up with a formula that from a value say in A1, will count itself and the number of blank rows, which will vary between values and change on a daily basis, to the next value in column A and put the result on the same row as the value (blue values in example data).
Thanks, any help is greatly appreciated in advance and please let me know if I need to provide additional information....
mrubel99
Last Activity: Feb 23 '12, 10:08 PM
Joined: Oct 31 '07
Location:
-
Excel - Count Blank Rows to Next Value
-
Hi Stuart,
Thanks once again for the response. Like you suggest, I am currently dumping the data into excel to run the quartile calculation and then bringing the results back into the database, it works, but its a little clunky.
I have been working on trying to find a more "dynamic" solution for this quartile calculation. I have been able to build a series of six queries that will work for a single series,... -
SELECT TOP 50 PERCENT for group?
Does anyone know how I would modify this query so that it will return the TOP 50% FAC_METRIC values for each PROJECT_NAME?
I have read a few posts about using a subquery as criteria for field FAC_METRIC?
But, I can't seem to make it work???? Thanks!
SELECT qryQuartileStep 3a.PROJECT_NAME , qryQuartileStep 3a.SYSTEM_FACIL ITY, qryQuartileStep 3a.FAC_METRIC
FROM qryQuartileStep 3a
ORDER BY q... -
Stewart, the main and the subform do have a one to many relationship. The subform is showing line item detail for the project in the main form. The idea was the the user could filter the line items in the subform and exclude them from the project. Through the exclusions the totals for the project on the main form would adjust. Anyway, I was able to use an update loop to accomplish what I needed.
Regards,
MikeLeave a comment:
-
Thank you Stewart for the response. The query is not picking up the criteria from the filter for some reason. The code runs but updates all of the records under each project name?Leave a comment:
-
Subform Filter / Update Issues
I have a subform built into a form in Access 2007. I would like the user to be able to filter the subform using their own criteria by right clicking the column header in the subform. Once the user has the subform record set filtered as they want I would like them to be able to click a button on the main form that will set the yes/no field [EXCLUDE_LINE] in the filtered subfom data set to true.
Here is the code I have been trying... -
Nico - Thank you again for all of your help. The other branch of this code works, however this string is resulting in a runtime 3061 - Too few parameters. Expected 1 when a filter is on in the subform. I can't figure out why?
[code=vb]
CurrentDb.Execu te ("UPDATE tblUtilizationD ataAll SET Exclude_Line = -1 WHERE [PROJECT_NAME] = '" & Me.Text81 & "' And " & Me.tblUtilizati onDataAll_subfo rm.Form.Filter)...Leave a comment:
-
Nico - Thank you for your response. I started to work with the code you provided and here is what I came up with - It keeps resulting in a runtime 3075 error, missing operator? Not sure what I am missing here. Thanks again.
If Me.tblUtilizati onDataAll_subfo rm.Form.FilterO n = True Then
' filter has been specified
CurrentDb.Execu te ("UPDATE tblUtilizationD ataAll SET Exclude_Line = -1 WHERE [PROJECT_NAME] =...Leave a comment:
-
Update all Selected Records
Hi,
I am working with access 2003 / XP and this is my first post to the forum and I am pretty new to Access.
I have a Main single form with a subform built in. I would like to add a button on the main form that will change the yes/no fields in the records on the subform to yes. Also, if there is a filter applied, I only want to update those records that are filtered. The filters would only be of "right click-filter...
No activity results to display
Leave a comment: