Search results

  1. 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...
  2. 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...
  3. 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...
Back
Top Bottom