Recent content by phong919

Can someone look at this update statment i just wrote? It's giving an error. i.e. UPDATE [Upload Trades] LEFT JOIN UploadAccts ON [Upload Trades].CustAcct = UploadAccts.CustodyAccount SET [Upload Trades].Client = [uploadaccts].[client], [Upload Trades].Account = [uploadaccts].[account] WHERE...

Thank you for the sample. but it's not what im really looking for. I'm looking more of check reconciliation. Trying to find an easy way of doing it.

Is there anyway i can get it for free? like a demo or something?

Hello, Does anyone know where i can get a copy of the check writer sample database for ms access 2000? thank you.

This file is not from excel, it's coming from a flat pipe delimited file. Thanks for the replies. Let me try and see if it works.

Can i write that in my query?

Hello Can someone help format the date correctly? I'm currently linking a flat file in access and then creating a table afterwards. The date comes in the following format below: i.e. 30102006 - txt type I wanted the date to look like - mm/dd/yy. Thanks for the help.

System meaning the database i already have. I guess i'm looking more of a form to create. I just do comparison between the file and the database already built. I wanted to create some kind of form so that everyone can use it. thanks.

Hello, I'm trying to create a form or some kind of database that does a comparison between a flat file i get and what the system has. Can someone guide me in the right direction on it? Any example would be great. Thank you.

Hello, I'm trying to show the date when i run my report on the report header. I'm not sure on how to do that, can someone help?

Hello, I'm trying to show the date when i run my report on the report header. I'm not sure on how to do that, can someone help?

Hello all, I'm fairly new at access and have been stumped at this problem. I download a csv file from the internet and what i wanted to do is just imported straight to a table from access. Some how the csv file contain some excel function that looks like the follwoing - i.e. =T("SOME TEXT")...

no there isn't anything similar to that. How would is start this?

Hello all, I need some assitant in building a simple check reconciliation database. I was wondering if anyone can guide me in doing so? Or if anyone has some kind of sample i can use that would be great. thanks

OMG the CSTR worked. Thank you so much.