Recent content by Sako

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

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

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

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?

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

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

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

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

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?

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