Re: SQL Statement

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I'm not sure what you mean. Where did "new table" come from?

If I do an update query, joining on the matching (?key) fields, and use the
"Update To" "cell" to indicate the new value, Access does this (NOTE: this
is via the design view window).

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ispfemme via AccessMonster.com" <u36669@uwe> wrote in message
news:76ca7fb5e37de@xxxxxx
I did use two separate queries, but the appending one is the only one that
seems to be working. How can I get the old information off of the new
table?

Jeff Boyce wrote:
If you are trying to both update and append, I usually rely on two queries
to do this.

Regards

Jeff Boyce
Microsoft Office/Access MVP

I posted earlier and fear I may have worded things wrong.

[quoted text clipped - 22 lines]

Thank you so much for getting through this

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200708/1



.

Relevant Pages

  • Re: Nz problem
    ... Jeff, the project number field may or may not have a number in the table. ... a number is entered in my form then only records matching my entry matching ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ...
    (microsoft.public.access.queries)
  • Re: Using an unbound texbox to find a record in form
    ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ... Private Sub Command146_Click ... Dim rec As DAO.Recordset ...
    (microsoft.public.access.queries)
  • Re: Alpha key to surrogate key
    ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ... if the customer master table is in the form. ... that a surrogate key would speed things up although, ...
    (microsoft.public.access.formscoding)
  • Re: Which the best option ?
    ... How are Cars related to People? ... One Person can have many pieces of Equipment. ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Which the best option ?
    ... set up the tables so that there is something in common between the ... You have to tell the database ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ...
    (microsoft.public.access.tablesdbdesign)