Recent content by liozzi

CJ and David, wish you have a Merry Christmas and Happy New Year!!! I'm taking vacation and won't be back till mid January 2014. Many thanks to all of your help guys. This forum is rock!! :)

CJ, I did not put index in the query. Maybe that's why it takes so long. Could you please tell me how to insert the index query into the last query that you sent? Many thanks!!

Crazy Monday before holiday. So much enjoyment in these upcoming holiday!!! @ CJ_London. The sql seems work. I tried it and the first couple hundred rows populate correctly but now it seems freeze and it’s been like that for almost an hour. But I’ll let it run overnight to see how it works...

Hi David, I am stuck with the code. Please find the attached pdf. I can't make it work. Could you please give me a feed back? Thanks and have a good weekend !! :)

Will do. I'm about to try it now. Thanks again David!!:)

Ups sorry just saw your reply :eek: Can't thank you more :) That's pretty intimidating. Thanks again for your help. I've got to figure it out how to make it work based on your instruction. I'll post the update. Thanks again!!!

That's sound awesome. Yes, I didn't name it just 'date'. Thanks for point it out. And yes, don't worry about RAM. Any help is appreciated. I think for my typical data file that i have it needs brute-force approach. :) Thanks again!!

I'm thinking of if I could have customer id and date in the same row, it would be easier for me to tweak it. So to summarize it I want the date and customer ID in the same row. Do you think it's possible? otherwise might have to cut the file in the smaller smaller sizes (which i avoided) and do...

No, the text file is not a csv file. CustomerID is numeric. Dates always formated as mm/dd/yy There's some other columns other than date and customer ID, such as let's say price and quantity. We're dealing with approximately more than 1 million rows. that's why I can't use excel. This...

Yes. Relational database. Appreciate your help!!

I need to clean up the data from text file. The cleaned data will be use as the raw data for my other analysis. :banghead:

Hello, I need to clean up data from text file which is huge. I wonder if Access Expression Builder can mirroring "IF function" from Excel Here is what i am trying to do The data consist of multiple customer and multiple date. But the layout only specified customer ID once eg. CustID : aaaa...

Uups.. i asked in the wrong category. Now move the question to the right one I hope:) i am a novice in ms access so really need help Wonder if i can have a count if function inside the iif function. In excel i will create a formula like this =if(countif($a$1:$a$100,a1)=1,a1,"")) Is there...

Hello, i am a novice in ms access so really need help :) Wonder if i can have a count if function inside the iif function. In excel i will create a formula like this =if(countif($a$1:$a$100,a1)=1,a1,"")) Is there anyway that i can create that kind of formula in query criteria? Thanks in...