update query

Good Afternoon! I have a series of updates to run on a table and I was hoping to automate them with one click. I tried using the execute method as described here: https://www.fmsinc.com/MicrosoftAccess/query/action-queries/SuppressWarningMessages.htm The problem is, when I put my query name...

Iam try to create an append query, in order to, insert records into an already existing field (using 2 different tables). Basically, I want to insert the dates from a column (field) labeled “GraduationDate” that is located in a table labeled “OrderHeader” into a table labeled...

Hi. I have two tables, both of which have the SKU column as the unique identifier. Table 1 has 32,000 records, Table 2 contains an updated version of about 6,000 of these records. Field names are the same for both tables, it's just the information that is different. I would like to update the...

Hello: I'm using MS Access 2013 & SharePoint 2010. I’m trying to create a table in Access by linking to an existing SharePoint list. I want them to be linked, so that I’m capturing any data changes made and/or new records in the SharePoint list. However, I do not want changes that I make in...

Hello all. I have a table that I am consistently adding records to. I have that part of my database complete and working. However, I am looking to find out the proper way to setup a new update query. I need this update query to prompt me once for a specific date, and then it fills all the...

I have a table (tbl_transactions) which has a column(transaction_date) that holds dates in this format mm/dd/yyyy. The file that is imported has the wrong dates, shows 2005 instead of 2015. I need to run an update query to correct the dates by adding 10 years to each date in the...

Hi There, I am trying to run an update query using two tables, Table1 and Table2. I am updating a new field in Table2 to the correct ID number from Table1, using an existing field from Table2 (which also exists in Table1, the reason for just trying to get the ID number from Table1 and avoid...

I'm trying to update a field in a properties table to reflect the minimum date found in a daily readings table where the property id's match. Can someone look at my SQL and let me know where I'm going wrong with this? Thanks! UPDATE tblDailyReadings INNER JOIN tblProperties ON...

I have a “Schedule Updates” subform to allow users to schedule future changes to a record on a specific date. These future changes populate tbl_ScheduledUpdates Simple Query qry_ScheduledUpdatesBase finds records <=Date() that now need to be changed. Update Query qry_ScheduledUpdates...

I have a data-entry form (frmTDMEntry) into which the user enters about 15 fields of data into the table t_tdm. When the user tabs to the next blank, new record, I want Access to run an update query on the t_tdm. Based on the fields that were entered in record #1, I have an update query...

I'm sure there's an easy solution to this that I'm overlooking, but here's my problem: I have a table in Access that already contains some data (which I would like to keep). I have about 24 identical tables (same column names, same records), except these tables contain data in the cells that...

Deear All, I am a self taught (and not very well) user of Access 2007. I have a table that must contian unique records based on some key fields (item number and purchase order number). The table includes an AutoNumber field that adds a sequential record number. This can tell me the sequence...

Hello again Today I have a table with a column called 'Concat'. This column contains multiple values. I have an update query and I want to update another column with the occurence # of the corresponding 'Concat' value. What do you think is the best approach? Just to demonstrate this is how I...

Hello I'm struggling to think of a 'not so complicated' way of achieving similar to an approximate VLOOKUP. I have a large table, and one of its' many fields is 'Days Overdue', which can be any integer greater than zero. I would like to update another existing field called 'Aged Bucket' to...