Search results for query: *

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...

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...