473,396 Members | 2,038 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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
Nov 22 '10 #1

✓ answered by 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.

5 1960
NeoPa
32,556 Expert Mod 16PB
You are appending (INSERT INTO) rather than updating (UPDATE).
Nov 22 '10 #2
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!
Nov 22 '10 #3
NeoPa
32,556 Expert Mod 16PB
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.
Nov 22 '10 #4
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.
Nov 22 '10 #5
NeoPa
32,556 Expert Mod 16PB
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.
Nov 22 '10 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

9
by: msnews.microsoft.com | last post by:
Hello! I'm Jim by asp How can show "abc" in textbox when click one botton?
1
by: Solx37 | last post by:
I am trying to figure out how to prevent scrolling when I append text. It scrolls to the bottom whenever I use AppendText. It jumps to the top whenever I += text to the Text property.
2
by: VBLearner | last post by:
How to close the parent and all child forms together at once when click on parent window's close button X?
1
by: ChrisMoss | last post by:
I have written a macro that I want to repeat until there are no more records to append (i.e., append zero rows). Is there a way for a condition to be applied to the macro that can detect if no...
13
by: MLH | last post by:
I have a form, frmVehicleEntryForm. On it is a subform control named frmAddnlOwnrListSubForm. The subform control's source object is frmAddnlOwnrListSubForm. When I click on the subform control,...
0
by: abdulazees | last post by:
when click button i want to print autometicaly reportveiwer data, i not need to show reportviewer.
1
by: elriez | last post by:
hye all currently im doing a project that need to include the sound..i already include the sound by simply import to the library and drag it to the stage..the sound can play well..the problem...
5
by: hidayu1986 | last post by:
how to disable textbox when click on radiobutton using VB script on Visual Studio.Net 2005. currently i used this coding but it is not functioning. Private sub...
2
by: lisa007 | last post by:
I have a contact form that send goes tru this validation page if everything corrct this php page will echo the form sumited succefully but the problem is evrytime the user clicks submit the data gets...
6
by: Kaloyan Krumov | last post by:
I have the following set up: Tables Supplier SupplierContacts Forms SupplierRegform SupplierContacts - subform On the main form I’m using tab control with two tabs. The first tab contains...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.