Search results for query: *

I have a database with 30 queries based on one table: tblCustomers. The table name was changed to tblCustomersOld. How can I change all 30 queries to reflect the new table name without having to open each query and edit individually? My expertise is SQL; I am not a VBA programmer but can stumble...

Hello, I have a single table (tbl1) with 4 columns: StoreName, StoreOwnerID, ProdSold, Sales. It looks like this: StoreName StoreOwnerID ProdSold Sales ------------------------------------------------------------- Store1 001 100 1000...

I am looking for the proper syntax to change the size of 2 or more columns in my table in one query. Here is what I have to change the size of just ONE column: ALTER TABLE MyTable ALTER COLUMN [COL1] char(6); But, what if I wanted to change the column size of COL1 and COL2 in the same query...

I am trying to increase a field's value in tbl1 by 2 if the same account number exists in tbl2. I think I may be partially there but Access returns an error. Here's what I have... UPDATE tbl1 SET fld = fld+2 WHERE (SELECT T1.account, T2.account FROM tbl2 T2, tbl1 T1 WHERE...

I have a very large table that I am trying to replace text in. I would like to design, using SQL, a query that will replace a string with a new value only if that string is part of a pre-specified group of values. For instance: In the CODE field, replace all the ocurrences of: 543, 545, 548...

I had data in a char. field that was in the form 0000-000-0000. After stripping out the dashes to make the data all numeric, I tried to convert the field from char. to long integer. Access errors out (table contains 280,000 records). SO, I thought I would outsmart Access and create an exact...

I am trying to automate the setup of the printer environment of 150 users that all have local printers attached to their w/s. I have set the advanced settings of the printer and exported the registry hive [HKEY_CURRENT_USER\Printers\DevModePerUser] to a .reg file on the server. At user logon, I...

I am trying to make a simple "data-definition" query in Access 2002 and cannot due to "invalid syntax" error. Here is my Query: CREATE TABLE Table1 (COLUMN1 number (20), COLUMN2 text (30), COLUMN3 text (30)); In my query, if I replace "number" with...

I am trying to merge two fields into one field in the same table. i.e.: Field 1: City Field 2: State Desired result: a new field named City-State which contains the merged data in the format of "City, State". Thanks in advance!! ts