I have downloaded a XML file imported into access
converted to table created a make table query to give only
those records required. I now need access to update
records in a main table from the new table - basically
filling in the blanks with the downloaded data.
Re: To change negative to positive in MS Access ... If you want to use the UPDATE query method and you will be importing new data into the table, ...UPDATE query that will only change the numbers that haven't been changed. ... changed data or if it is new, unchanged data and then build your UPDATE ... (microsoft.public.access.queries)
Re: Update query after an append query?+ ... computer so that I could tell when and if I get the update query to work. ... that if you created your query under a different ANSI SQL query mode than ... the current mode of your Microsoft Access database then your update query ... (microsoft.public.access.formscoding)
Re: Append import data to existing record ... I'm glad you've got the key query working.... With the update query open in Design View: ... Split the filespec apart and reassemble it into a ... Function BuildJetTextSource(ByVal FileSpec As String,... (microsoft.public.access.externaldata)
Re: To change negative to positive in MS Access ... Rick's method is just a calculated field in a SELECT query.... Klatuu's method is an UPDATE query and it WILL change your underlying data. ... If you are importing, this can be done using the update method, but it can be a little tricky. ... you are importing data from an external source and this field is negative in these source files,... (microsoft.public.access.queries)
Re: Appending records to a table ... add a Yes/No field to Table2, i'll call it NoMatch.... use the query wizard to create an Unmatched Records query, ... turn that query into an Append query, to append the records to Table1. ... (microsoft.public.access.modulesdaovba)
