Access - append new data to existing rows

[Naides81]

Hi All,

Firstly apologies - I've never really worked with Access (I'm more of an Excel human).... I have been given the below problem and am pulling my hair out in large bunches so any assistance would be greatly appreciated.

I have a master file (csv) that will contain data in rows that needs to be used for outbound calling, the rows have a unique identifier and the master file needs to be updated with outcomes (which will be reported on daily). I have managed to get the data from our phone system to replicate all the fields / values per the master file.

I am trying to figure out a way of appending the new information onto the existing rows without deleting what is already within the master file. For example, we may try and contact a customer on day 1 but are unable to get through - this information will be on our daily report. We would try again the next day so would want the information to go into the relevant columns for that day (but not delete or overwrite the previous information)

I assume that this is something that is achievable in Access I just don't really know what i'm looking for. If you're aware of a similar thread / link to a webpage (anything)!

Thanks in advance,



Naides

[CK76]

How is your table structured?

I assume update does not add any new column to the table, but updates some field in existing table.

You'd use UPDATE statement to update specific record.

Ex:

Please Login or Register  to view this content.

Note that you must always include WHERE statement, or all record in a table column will be updated with specific value.

Exact syntax will depend on your table/column structure.

If you have 2nd table where update info is stored. You can use INNER JOIN to update multiple record in one shot (2nd table record should have flag column or records removed after update).

[MarvinP]

Hi Naides,

It sounds like you shouldn't update any of the data but simply add it to the bottom of the collected data table. What are the field names for your master table? Because you have multiple calls to the same number you likely have a Number Table and a separate Call table. They link using the number. I just don't see an Update Process needed in what I'm imagining.

[CK76]

Ah, I may have misread.

I thought something like table holding ANI (Phone number), Name, Status, LastCallDate etc.

With Status & LastCallDate being updated based on outcome of action/tracker.