How to stop my records from multiplying when I click Append?

[Fspinelli]

Happy Monday,

I have a table (Master) and two queries. The first query (qry A) takes data entered into a form and converts that data into various symbols. The second query (qry B) is an append query and takes qry A and appends the data to the table (Master).

When I open up the Master table there is one row that shows the data entered and another row with the same data entered plus the symbols it created. It makes two rows of the same data only one row supplies the symbols (just need that row).
What am I doing wrong?

Thank you.
Faith

[NeoPa]

You are appending (INSERT INTO) rather than updating (UPDATE).

[Fspinelli]

That's what I'm doing wrong?

I went online to learn about the update and it gives me append instructions. Do you have a link with better instructions?

Thank you, NeoPa, you've been a great help!

[NeoPa]

FSpinelli:
That's what I'm doing wrong?

Yes indeed.

There is unlikely to be a need to go online at all even Faith.

When editing a query in Access you can change the type of query to Update by selecting Query / Update Query.

If working directly in SQL there is a full explanation of most of Jet SQL (the type used by Access) in the Help system. See Finding Jet SQL Help.

[Fspinelli]

OMG that was easy. Thank you.

However, but now the data that makes up the symbols gets updated, but the symbols generated from that data are no longer writing to the table.

[NeoPa]

I suspect you're doing something wrong then Faith :-D

As I have no information available as to what you are doing though, I can be of little direct help at this time.