Recent content by dobe1

Thanks, but this will not be a one time shot.

I just tried the above and it did not work. What I did do that worked was: update table set field = mid(field1,1, instrrev(field1," ")-1) fortunately there was a space just before the "wierd Y's". I will try your (the above) code again. It is one I would like to keep in my library, if I...

COMBS ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ I brought this data into my GIS, and found the padding actually to be the series of "y's" with a colon on top. How do I get rid of this.

BTW, this is Access 2003

I need to remove padded spaces from several fields, and the Trim(Name) and RTrim(Name) does not remove the spaces. Any suggestions?

Unfortunately, I cannot see where I can edit this post. The last post should have read " I had hoped from my descripton of the above that it were obvious I was using a flat file.....yada yada yada

PHV, I had hoped from my description of the above, that I was using a simple flat file in order to populate these values outside of our enterprise system. Again, The flat file resides within MS Access. The values well be inserted into our enterprise system. Dobe

PHV, I am afraid this resulted in the seed being 1, and from there the last record was N+1, where N = record number. The 500000 did not act as a see.

These are customers from a possible acquistion. Our enterprise system has a self generating field, which assigns customer numbers. Therefore, I need to take the highest possible value, and self generate from there. I suppose a better way would have been to simple populate the field with...

I have a table with 16,000 pre-existing records. I wish to simply go into the design view, add a field auto increment, and seed the starting point at 500,000. How can I do this? Thanks in advance, Dobe

Moderators, I appologize in advance if this is not in the correct forum. I need to know what it would cost to purchase SQL Server 2005 for six seats. From whom do most IT pros buy this type of software? Thanks, Dobe

Thanks, Dobe

Hi, I'm trying to use the following code, which a sample I found is "SQL Cookbook" by Anthony Molinaro. with x (cname,ccust#) as ( select cast(cname as varchar(100)), ccust# from cust_table where cmstc# = 0 union all select cast(x.cname + ' - ' + e.cname as varchar(100)), e.ccust#...

Thanks again for your patience and your indepth help. I must close down for the day. I will be with y'all tomorrow. Dobe

No, actually, I wish to have an update query call the Days_Current query. In order to do this, it would make no sense to have the "into" statement in the code. I only put the "into" statement in the code in order to test the possibility of the problem being a reference to the query vs. a...