Re: Appending Tables

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

From: Lynn Trapp (ltrappNoSpam_at_ltcomputerdesigns.com)
Date: 01/20/05 

Date: Thu, 20 Jan 2005 08:09:08 -0600

Well,
You should have a form for entering and updating client information. That
should always contain the current information. In the after update event of
your form run an append query to append the current record to the history
table. Initially, it will be the same as your current client information,
but the next time that client record is updated, it will be previous data. 

-- 
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
"Sheri Emery" <anonymous@discussions.microsoft.com> wrote in message 
news:0c7c01c4fe68$80d9fc80$a601280a@phx.gbl...
> Hi Lynn,
> It does give me the historical record, but I need only the
> current status to appear in other reports, so I need to
> keep the current data for each individual in a "current"
> table, and only move historical data.  I want one current
> record for each client only.  Thanks for your help.
> Sheri
>>-----Original Message-----
>>Sheri,
>>Why doesn't appending the record to the history table not
> do what you want?
>>
>>-- 
>>Lynn Trapp
>>MS Access MVP
>>www.ltcomputerdesigns.com
>>Access Security: www.ltcomputerdesigns.com/Security.htm
>>
>>
>>"Sheri Emery" <anonymous@discussions.microsoft.com> wrote
> in message
>>news:071501c4fe62$5372d060$a401280a@phx.gbl...
>>> Hi,
>>> I want to append old records to a "historical table", so
>>> I've created a Query and used the Append option.  I'm
>>> running into a bit of a snag though - I want to keep the
>>> most recent data for each client in the current table,
> but
>>> I'm not sure how to specify this in the query criteria.
>>> Basically, whenever there is an update, I want the old
>>> records for that client in the historical table and the
>>> updated data to appear in the current table.  I want to
>>> use this option so that my reports grab the most current
>>> data, but we also have a historical record of when
> changes
>>> occurred.  I really appreciate any assistance you can
>>> provide.
>>> Thanks,
>>> Sheri
>>
>>
>>.
>>

Relevant Pages

  • Re: copying large data on production environment
    ... At some combination of configuration and data volume, ... I need to write scripts which client side will ... your systems load. ... Append may or may not make a difference, since it's purpose is to add ...
    (comp.databases.oracle.server)
  • Re: NEWBIE:thanks for the help-still needed parser for 1st para.,
    ... -Client Name is in the very first paragraph, ... Client data may, or may not span multiple pages. ... Relevant client information is contained ... may not contain the page break, but I'd still like to be able to capture ...
    (microsoft.public.word.vba.general)
  • Re: Reports Not Printing Similar Names
    ... Table 1 = Client Household ... Fields = HouseholdID, HouseholdName, FirstName, StreetAddress, Phone, etc ... Report is based on a query that creates a new field: ... Client History, sorted by date ...
    (microsoft.public.access.reports)
  • RE: Interested in thoughts on keeping the integrity of historical
    ... Address2, City, St, Zip, and an Name Change Flag. ... then I write out the Address history record. ... "hollyylloh" wrote: ... So, for example, normally I would enter client information (name, ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Interested in thoughts on keeping the integrity of historical
    ... Dennis please see my coments below: ... Update event, I check to see if he address had change. ... then I write out the Address history record. ... So, for example, normally I would enter client information (name, ...
    (microsoft.public.access.tablesdbdesign)