I'm trying to move information from a table to a set of normalized tables. To do this I'm trying to use an append query. The destination tables has one main...

Hi: I have a bunch of tables in which I'd like to globally update the BLDG_NO field. The data in this field does not coincide with the data in the BLDGMaster...

Hi, Can't get this query to work. Any ideas ? Have 2 tables RANK has 3 records TEST is 1 record Store R ...

I have a table that contains prison bunk numbers: 1-101B 1-101T 1-102B and so on 1 means housing unit one hyphen 101 is the cell number B or T is bottom or...

I have two tables with the same 4 columns. The rest of the columns are different. Table2 can have more rows than Table1. I'd like to get these 4 fields updated...

i currently have a table that reads as follows: AccountID - State - Jursidiction - Revenue 123456 - NJ - 1 - $456,256 123456 - NJ ...

I am trying to updates some costs in my database. I have the following tables: tblCopies(CopyId, BookID, Condition,Price) tblBookDetail(BoodId, ISBN,...

i want to add a field from one table to the already existing value in another table. I am trying it in a update query but can't get it to work... here's what...

I need to update a column in a table to equal 10 characters long. If the field is less than 10 characters I need to add zeros to the right of the value in the...

No one answered my previous question. Probably I did not explain clearly what I need to do. I did a pilot study for an assessment survey and created query...

what is the difference between "not like" and " is not" Could anyone tell me what is wrong with this query. UPDATE table1 AS table1 SET table1.field1 =...

I have used this similar construction to do update from text boxes to a table but this one doesn't seem to work right and I am not sure what exactly is...

I need to update a field in one table as the product of two fields in another table. If I create a DSN called "test" and a linked server in SQL Server,...

What is the Access equivalent of UPDATE table a FROM table b SET x = b.y WHERE a.c = b.d

I am working with two different databases; however, the newer database contains information needed from the older database. Is there a way to copy the...

Hi all, I have the following query: UPDATE plans SET plan_date = ( SELECT Min(calendar.date) FROM calendar WHERE (((calendar.completed_yn)=False) AND...

Hi, May I know how can I update a column (ColumnA) in one table (TableA) with the value of another column (ColumnB) in another table (TableB)? The 2 tables...

Is there any way to update a field on a table to the value that a function returns?? I had a form where I had the DateExpires field based off a function that...

Hello, i want to make a update query, but i can't. In my event: i have a query1, with field Name, Number with SUM for each record from table1, and group by...

Hello, I'd like to create a new number field from a "endnote" field. The endnote field has entries such as "Endnote 1" and "Endnote 2". I'd like the new...