Hi,
I have a spreadsheet filled with an employees' checking times. I want to remove the bottom and top ten percent of checking times per day. However, there are hundreds on days within the spreadsheet and all the days are in the Date Column. I'm assuming a if - percentile function would be the best way to isolate these bottom and top times but I can only do that for all the days as a whole. I need to do this per day over the course...
ndd25
Last Activity: May 17 '17, 06:40 PM
Joined: Feb 17 '17
Location:
-
Percentile Array Functions
-
Hmm, I think I was hoping for something a little more dynamic (i might have to come up with some vba to do the trick for issues other than months) but for now it'll work just fine! I restricted my query for the previous 11 months and the current month. That way all the data appears from a month associated only with one year. And then I altered the column headings to month excluding the year as you suggested. This solution will work for me. Thank... -
Thanks jforbes,
I've attached pictures of my query and report designs to help. You're right, the column headings of my report are just the months listed in the data. Right now, I have data only for Jan 2017 and Feb 2017. With time, I will be adding data for each month. In Jan 2018, Jan 2017 will need to drop off and this will need to continue.
Is there anyway to do a separate query to pull the months I want and have that...Leave a comment:
-
Rolling YTD Column Headings in Crosstab Query Report
I'm new to access and vba. I created a crosstab query with
a. User = Rowheading, b. Date = Columnheading c. rate = value.
Monthly productivity numbers will be added overtime so the column headings need to be dynamic with the months for a rolling ytd metric.
That being said, the report can have a fixed amount of 12 column headings, I just need the labels and values on the report to be dynamic.
... -
Thanks, that idea works for me. I'm a little stuck. I have:
Dim db as Database
Dim tdf as DAO.TableDef
Dim rsin as DAO.Recordset
Dim field as DAO.Field
Set db = CurrentDB
Set rsin = dbs.OpenRecords et ("Daily Info 2")
rsin.MoveLast
Do While Not rsin.BOF
rst.MovePreviou s
I'm lost on the language for storing a field value moving to the previous one...Leave a comment:
-
Calculated Table Field based on Previous Record
I understand that Access stores information as members not as related records...that being said.
I have a large set of data with a userid field, receipt check time and date. Each userid has approx. 150 receipt check times in a day. I need to calculate the individual duration time of each receipt check. In excel, I sorted the time by date, userid name, and receipt check time ascending. If the userid in row b was equal to userid in...
No activity results to display
Leave a comment: