Recent content by Sako

  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

    Hidding duplicates

    Hi, Step 1. Modify your indexes as I did in my DB. This way, you will be sure that no duplicate records with str1, str2, str3 will be the same. Just follow the steps in my DB. There is most likely a shorter way to do it, but this is my solution. You can play around to make it better but it...
  3. S

    Percentile UDF

    Hmm, thanks jdraw. my UDF does that exactly. I'll keep searching I guess...
  4. S

    Hidding duplicates

    Can you make it more clear? As for Peter, (ID 2001), there was a change in strDetails4. Which StrDetails are important? which ones are not?
  5. S

    Hidding duplicates

    Hi, I've done something similar to this before. Can you post a sample of your database (fill in with random values if the data is confidential).
  6. S

    Percentile UDF

    Hi Gemma, yes that is exactly what I want in the extra field. Any ideas? Thanks
  7. S

    Percentile UDF

    Hi, I didn't think about that! Here I attached a 2002-2003 Access db. Thanks, I'll post the UDF down here: Option Compare Database Public Function SAS5Q1(TableName As String, ValueField As String, TickerName As String, p As Single) As Single ' this function determines the value for the...
  8. 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...
  9. S

    Query Most Recent

    I am wondering whether it is possible to add to this code the requirement that it has to select exactly 3 numbers to do the average. Using select top 3 might result in selecting only 2 numbers in case a truck would not have 3 weights.. This would result in a faulty average, any help on this?
  10. 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