Append/Update Query

[rizabdullah]

Hi Guys

I am fairly new with Access. I have created a database
After running some queries, a table gets generated with invoice details. What I am trying to achieve, with no luck :banghead:, allow my users to update COLUMN field within this table. They have a form, on which, they select invoice number, supplier, etc; then add comments against that record on the table. How do I do this, please advise.

Bear in mind; we need to be able to hold old/previous comments against an invoice and just add new comment to COMMENT field without overwriting/deleting previous comments.

Many Thanks

 

[plog]

After running some queries, a table gets generated with invoice details...

That doesn't sound right. MAKE TABLE queries are usually a sign of poor structure. Why must you create a whole new table?

They have a form, on which, they select invoice number, supplier, etc; then add comments against that record on the table. How do I do this, please advise.

Advise on what? The sentence prior to your question makes it sound like its working.

we need to be able to hold old/previous comments against an invoice and just add new comment to COMMENT field without overwriting/deleting previous comments.

If one invoice can have multiple comments, then you need a new table to hold those comments. Build a new comment table and add a subform to your invoice form to allow users to add multiple comments.

 

[rizabdullah]

Apologies, I guess I am not good explaining scenarios.
Advise on how do I transfer comments from excel to access table (like to preserve old comments)
Actual make table columns COMMENTS is blank; users will populate this column based on invoice number. I need to be able to append/update this COMMENT field back into the MAKE TABLE.

Appreciate your time & effort.

 

[Grumm]

I would start by making 2 tables. One to store your invoice number and other data. A second table for your comments. With a comment_ID and Invoice_ID then link that Invoice_ID to the id of the first table. This will allow you to add as many comments as you want.

 

[rizabdullah]

Many thanks, it all worked