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
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.