Search results for query: *

Never mind solution found

I create functions for a complex calculations in my DB. I call the function in an update query to place the result in a table. When desiding the update query I would get all the variables to feed into the funtion like the following example. EXAMPLE: Sample («Test1», «Test2», «Test3», «Test4»...

My database is structured in a way I can run all the queries that begin with "IP - 0" however can I extend the wildcarding so I run all the queries that begins with "IP - 0" and end with say " -X". There are a lot of queries in the DB and the staff marks each applicable query by placing a "...

I am trying to create a new variable by concatenating two existing variables. The wrinkle is that they appear to be different data types. Batch# = alphanumeric character. Sequence = Nuneric I believe I know the proper syntax =Concatenation(<Batch Number> ,<sequence>) I tries to nest a...

TranMan, I still cannot run my update to remove the ' from the names. I copied the code into my module right after I open the output file and before I do all my record set stuff. I get and UNDEFINED FUNCTION ERROR in my SQl line.

Thanks for the tip ... There are a whole host of names with an ' in them. I Have to replace the ' in all of them so I was thinking of something like: UPDATE TestData SET LastName = Replace ( LastName, "'", "" ), FirstName = Replace ( FirstName, "'", "" ), But I can not get it to...

Worked like a charm. Now trying to write the code to take the ' out of the name fields ie. O'Brien. Thinking of a simple SQL find and replace. Thanks for your help

It Workedlike a charm however The third Party softrare will only accept a Coma delimited file How can I Modify so it is comma delimited

TranMan, I am adapting it to my exact data. The actual dataset has 34 fields and is over 700k records. I whould have it completed tomarrow. Thanks for you help. I think I am having a Problem with names that have a ' in them. Not sure still testing. Nick

Tranman. Thanks for the Help But Just a Few questions.. 1. In the line; rs.Open "Select * from cust where name = 'Nick'", It looks for Nick in the Cust field. However this field is populated with many different customers. If this is hard coded how will it look for the next customer in...

Can Some one provide me a little more help? [pc3]

Can Some one provide me a little more help? I am on a tight time line....

I thought that would be the general approach but it is beyond my skills. Can you Provide a little more help.. or example

I need to build a string from multiple records in a table that share common elements. Here is a sample of the data Data: Name Adress SS # Date Sales Code Nick 123 State 123-45-6789 1/2/2005 100.00 A Nick 123 State 123-45-6789 1/3/2005 200.00 B Nick 123...

I have an access table that looks like Field1 and Field2 and the Desired Action Column shows how I want to chage the table. Field1 Field2 Desired Action 4321 Keep 5678 Keep 1234 Delete 1234 xx Keep 1234 yy Keep 5678...

Thanks Crowley16 Can you provide me with a little more detail as I am a beginner. A code sample would be helpful

I want to import text tables into an Access DB, The files will always be in the same directory as the Access DB. The DB is an application to be copied by the enduser to thier part of the network with the proviso that the data files are put in the same DIR. The Do command requires a hard coded...