Search results

  1. S

    Use If through fields

    Hi everyone, I am so closed to what I want to do but I am stuck on some VBA loop. This table is not normalized because it is an excel file that I receive every week. So I'd rather just copy that file into the same folder every week instead of having to normalize again. Since this is built for...
  2. S

    Percentile UDF

    Hi, I have a UDF that calculates the percentile of a range of row. However, I've been uncapable of modifying the UDF to really do what I need to do. in the tbl_Nasdaq, there are 3 columns: -Ticker -Date_Text -Open What I'd like to have is a query that contains: -Ticker -Date_Text -Open...
  3. S

    Group By returns 2x the grouped category

    Hi, I need to make an AVG() per category. The average price will select the top 200 most recent days (the format of the date is a txt format like "20090819" ) of each category. What I also need is that if the category does not have 200 days, then not to select the category (If there is a...
Back
Top Bottom