Recent content by Clandon

Try this: update [tablename] set [fieldname]='Goodbye' where [fieldname]='Hello'

Thanks Kevin, I'll give it a shot and let you know how it goes! Thanks

Kevin: Guess I'm not used to calling procedures, be glad to learn from you how to proceed with it though, thanks, Cheryl

Hi GoDawgs: My boss wants the raw data files to have certain processes. First I import the raw data into tables in MSA2000, then I am manipulating and formatting using queries to load to SQL. He wants this as automated as possible, and wants them in a query. I have just noticed that the...

Hi Golom: Thanks for the response. I can't use sql as I am creating an upload query from a raw txt file. I'm getting close, but having trouble keeping the format of 9 digits to stick on the fields with 2 spaces. I will remember the advise for the Replace when I am writing SQL as I do have...

Thanks Golom and BB. BB: Access doesn't like the replace command in design view. Golom: Your formatting code worked great except for cases that I had 2 spaces, so I tried to alter the one space with 2, but can't quite seem to get it to work. Here's what I used.Test...

I have attempted to format an imported text field to be a fixed length of 9 for some fields that contain spaces. ex: sub-id 56892 000056 78 0000A 123 I thought the Format(Trim([sub-id],"000000000")) was great and have used it sucessfully in the past-or so I thought. The format...

I have been successful in creating an ODBC connection and linking to SAS dat files using MSACCESS2000. When I attempt to link to a sas view, I get the following error. "The Microsoft Jet database engine could not find the following file (SAS View File Name.) Make sure the object file...

I have been successful in creating an ODBC connection and linking to SAS dat files using MSACCESS2000. When I attempt to link to a sas view, I get the following error. "The Microsoft Jet database engine could not find the following file (SAS View File Name.) Make sure the object file...

Fred: If you must include the company name in the query too, and this is where the duplicate spelling is occuring, you will need to use a min on the company field and the totals. The totals should be the same, so if it takes the min total, it should work. Give it a shot. Cheryl

Mike, You are not talking to yourself.[smile] Glad I could help. Cheryl

Thanks for the help anyhow. If you happen to figure it out, please let me know. Cheryl [smile]

I have had this happen a few times years ago when I was using Access97. Sometimes a field would show nothing but #Error# or just a pound sign in the table. If you can find that record(s) and delete it, that may be the problem. Did you try to compact and repair the old database? Try using...

Hi Jim. Are you formatting it in a query or in the table design format box on the general tab in desing view for the table? The query works for me, but I was looking for a format to hold the import field so I wouldn't have to create an additional formatting query for linking purposes. Any...

I am importing a txt file with a field into a table that could be less than the desired 10 character length. I would like the field to import as 10 character with leading zeros if it is less than 10. I want to keep it as a text field instead of numeric. I am able to format the field in a query...