Re: Update current record information to a separate record status reco

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 07/31/04 

Date: Sat, 31 Jul 2004 06:45:06 -0700

Hi Pete!

Still trying to make it work as originally designed, I see!

Take a look at an Update Query in Access. You can use "Is Not Null" as a
criterion to update (from) a field that holds a non-null value.

My original design suggestion still holds. A "summary table/record" may
seem to help...

... but creating a "summary record" in a separate table only introduces the
potential issue of synchronization. That is, you will have to ensure that:
1) new information to your first table gets properly recorded into the
second; 2) any change to any row of information (old info, but modified)
gets properly recorded into the second, summary table; 3) no changes are
EVER made directly in the summary table, as this would cause it to fall out
of synchronization with what is contained in your "details" table. 

-- 
Good luck!
Jeff Boyce
<Access MVP>

Relevant Pages

  • Re: How to prevent duplicate entries
    ... user has already saved the record once, that saving a second time would only ... run an Update query, ... and use the Edit method rather than the AddNew method. ... And design the properly normalized tables FIRST, ...
    (microsoft.public.access.formscoding)
  • Re: Separating Fields in Access
    ... Then create an update query that will update both fields ... Open the table in design view and delete the original TrackingNumber field. ... How are we to know which of the 7 characters goes where? ... I would like the "Traking Number" to be broken up into two fields ...
    (microsoft.public.access.gettingstarted)
  • Re: Entering Data
    ... what I would do is open the table in design view and add ... > I need to extract records from another program based on a date search. ... > file into a Imported Records table. ... I have created an update query to ...
    (microsoft.public.access.queries)
  • Update Query Corruption causing headache
    ... I have a simple update query in an Access 2000 database. ... However the moment I reopen it in the design view it changes ... Every other update field is auto corrected also. ... Auto rename feature but the problem still persists can anyone help cause it ...
    (microsoft.public.access.queries)
  • Re: Memory Allocation in a Multi-Threaded Environment
    ... synchronization is no synchronization", the point being that you should ... This is usually a design error, ... Thanks for your response - it's really appreciated. ... local file system) the download will probably finish before the first bytes ...
    (microsoft.public.vc.mfc)