Re: How do I print only new records in Access?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 12/24/04

  • Next message: Mail Recipients Changing order of fields: "Access Design" 
    Date: Fri, 24 Dec 2004 04:46:46 -0800

    Phillip

    Consider, before you pursue this any further, revisiting your data
    structure. If you have identical tables to store data from different
    (months, counties, clubs, ... fill in the blank), you are likely "committing
    spread***" on Access, a relational database.

    Your task is made harder by the fact that you have to visit/refer to
    multiple tables, and you will have to modify how you refer to those tables
    every time you add/remove another (month, county, club, ... you get the
    idea, right?).

    On the other hand, if you had ONE table, with a single additional field for
    "county" (in your situation), you could query against that ONE table for ALL
    records matching a set of selection criteria. For example, you could use a
    DateCreated field to find all records added since that date.

    Which brings up another opportunity for normalizing your data structure.
    Any time you have a one-to-many relationship, you can create a "child" table
    to hold the "many" records, rather than, as it sounds like from your
    description, adding more columns ("... multiple document types and multiple
    dates of record entry for each client."

    I suspect you would find your task much easier if your data structure was
    better normalized. 

    -- 
Good luck
Jeff Boyce
<Access MVP>
"Phillip F" <Phillip F@discussions.microsoft.com> wrote in message
news:D8427578-C30E-4CDF-A729-E3C80E7429D4@microsoft.com...
> How do I print client records based on date of entry utilizing template
> created as MS Access report or as MS Word mailmerge document?  Information
> includes multiple client addresses, multiple documents types and multiple
> dates of record entry for each client.  The records to be printed come
from
> three tables.  The tables contain the same fields but are for different
> counties.  The mailmerge template has already been created but is not
> automated to print directly from the database. Thank you for any help you
can
> provide.
  • Next message: Mail Recipients Changing order of fields: "Access Design"
    • Quantcast