Search results for query: *

Hello: Envrioment: Access 2002 I have a field with data similar to the following: STUCK AT 55 TEMP N/INT N Notice the spaces between 55 and TEMP. I would like to elimitate the random number of spaces and replace with 2 spaces such as: STUCK AT 55 TEMP N/INT N Thanks in advance...

Hello: I need to update a field in a table with a random number between 1 and 9 "for each record". Example: RecordNum NewField 1 5 2 7 3 9 4 4 5 1 6 5 etc. When I attempt to use the rnd() function, I end up with the "same" random number...

:Access 2002, SP3 I have a datetime field that I need to query as follows: Between #2/20/2006 4:00:01 PM# And #2/21/2006 4:00:00 PM# So that I don't have to re-enter the date portion each day... How can I re-design this critera to look back (from 4:00.00 PM) each day, to 4:00.01 PM the prior...

Thank you! That will do the trick. I actually have another very similar field that I need to parse also. The only difference is that the field could be null, empty, or any number of mostly 3 digit sets of numbers, each set separated by a space. If you have a suggestion for this situation, it...

Hi All: Environment: SQL 7, Field = nvarchar (50) I need to parse 4 values from a string. The values will always be separated by a space, but will be of varying lenghts. Example: 90 0 329 419 126 0 132 258 114 0 14 128 104 0 18 122 342 0 193 535 Thanks, Jeff

I have a 300+ field dbase5 table that I need to import to MSSQL 7.0. My DTS import is failing I believe due to a 255 field limit with my Dbase driver. (Access 2000 also has this limitation). Can someone tell me where I might find a dbase5 utility to export the table to a comma-delimited file...