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

• Previous message: thiabu: "request template for personnel database (Access)"
• In reply to: Phillip F: "How do I print only new records in Access?"
• Messages sorted by: [ date ] [ thread ]

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
spreadsheet" 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.

• Previous message: thiabu: "request template for personnel database (Access)"
• In reply to: Phillip F: "How do I print only new records in Access?"
• Messages sorted by: [ date ] [ thread ]