Recent content by vas90

Worked beautifully! Thank you so much.

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

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.

That is very odd, I did not post that question in the other thread! I'm puzzled.

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

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

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