Re: Append Query Help!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Chris (Chris_at_discussions.microsoft.com)
Date: 10/11/04 

Date: Mon, 11 Oct 2004 10:01:01 -0700

Gah, I figured it out. In SQL view the query was selecting from both tables
instead of just one. For some reason.....

Thanks for the help

"Chris" wrote:

> Hmm. I'm not sure, little confused now.
>
> Let me explain a little more.
>
> I have a primary table which contains fields Last Name, First Name, etc. I
> want to add all the records from specific fields in another table and have
> them start at the end of the primary table in their appropriate fields. I
> start a new query and select append, then specify the table to append
> (primary).
> > > My query looks like this:
> > >
> > > Field: Lastname
> > > Table: Secondary
> > > Append To: Last Name (primary table)
> etc.
>
> The query appends each record 195 times instead of just once.
> "[MVP] S.Clark" wrote:
>
> > Append adds records, update will only update existing fields. Maybe an
> > Update is what you need, instead of the append. ??
> >
> > --
> > Steve Clark, Access MVP
> > FMS, Inc.
> > www.fmsinc.com/consulting
> >
> > "Chris" <Chris@discussions.microsoft.com> wrote in message
> > news:492F9342-8461-4D55-9EF9-6B31AAE4111D@microsoft.com...
> > > I'm attempting to merge two tables with similar records. I only want to
> > add
> > > 6 fields from my secondary table to my primary table. Last Name, First
> > Name
> > > etc.
> > > My query looks like this:
> > >
> > > Field: Lastname
> > > Table: Secondary
> > > Append To: Last Name (primary table)
> > >
> > > When I view the results the query appends each entry from the lastname
> > field
> > > from the secondary table to the primary table 195 times. Not cool!
> > >
> > > What am I doing wrong?
> > >
> > > Any help appreciated!
> >
> >
> >

Relevant Pages

  • Re: Membership database updates
    ... When you open any Query in Design View, click on the toolbar just next to ... black down-arrow where you can change your query to an Append or Update ... If you have any current members in your Import list, ... You mention Update Queries and Append Queries but I can't find how to ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Assign macro on After update event
    ... I don't see why you can't append the current record next scheduled date to ... it then try using an update query to update the dates in the new record. ... "Anna" wrote: ... maybe you can help me with that: all this macro is ...
    (microsoft.public.access.forms)
  • Re: duplicates query help & strategy for update queries with SetWarnings = False
    ... I have many many queries that check for orpaned data (for example, if there's a billing record with no matching custID in the customer table, I'm putting up a form with the unmatched data, and a quick way to update all unmatched to one archive type customer, etc. ... I was surprised to see duplicate entries in some of the static tables for dropdown selections, so I have to solve this one now. ... Once the user has handled all the problems, you enable the final command button at the bottom of the form, which executes an append query to add the data to the real table. ...
    (comp.databases.ms-access)
  • Re: Append Query Date Criteria Problem.
    ... Why can't I append some records? ... Choose Parameters on the Query menu. ... Access opens the paramters dialog. ... > End Sub ...
    (microsoft.public.access.queries)
  • RE: How to use Append Queries to add new records
    ... I sort of knew how the append query would work, ... > destination field name that you want to append those values to. ... > out new action queries. ...
    (microsoft.public.access.queries)