Search results
-
V
Filtering data with dates that have not been reached this year.
Worked beautifully! Thank you so much. -
V
Filtering data with dates that have not been reached this year.
Hello, I'm having some trouble finding/ building an expression to do this. I have 2 years worth of data (2009 and 2010) in query1. Each record has a unique date in the [date completed] field. We have only reached 8-11-2010 this year. I need to filter query1 such that 1. all current year to... -
V
Conditional expr: Assigning an index value to a range of numbers in a query field.
Haha, I'm completely perplexed. I'm assuming I asked someone on another forum, they posted here the same question, got the answer, then got back to me. -
V
Conditional expr: Assigning an index value to a range of numbers in a query field.
That is very odd, I did not post that question in the other thread! I'm puzzled. -
V
Percentile analysis function to eliminate outliers.
Hello, I'm a little puzzled as to how to go about making a percentile analysis function for access. I essentially have a query with an item number, start_date, end_date fields. Then I have another expr field in the query that calculates datediff between start_date and end_date. This...- vas90
- Thread
- Replies: 1
- Forum: Modules & VBA
-
V
Conditional expr: Assigning an index value to a range of numbers in a query field.
Hi jzwp22, thanks for your reply. I was able to create a module with the code to accomplish this. Function Frequency(A As Variant) As Integer If A = Null Then Frequency = 0 End If If A < 11 And A > 0 Then Frequency = 1 End If If A > 10 And A < 40 Then Frequency = 2 End If If A > 39 And A <... -
V
Conditional expr: Assigning an index value to a range of numbers in a query field.
Hi all, this doesn't seem too complex but I'm having trouble finding a similar situation online. I have a query with a field called IT Actual Hours. I would like to turn these hours into a weighted index. For example: IT actual hours: Number of hours-> assigned index value. 0-10 -> 1 11-39...