Re: URGENT Microsoft Access Inquiry

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 02/29/04

  • Next message: John Vinson: "Re: search query by date" 
    Date: Sat, 28 Feb 2004 19:35:35 -0700

    On Sat, 28 Feb 2004 15:12:41 -0800, "Kathy Areshenko"
    <anonymous@discussions.microsoft.com> wrote:

    >CHRONOLOGICAL documentation of job-related incidents: If
    >I were to enter data (from various notes I've
    >accumulated) regarding each incident, and simultaneously
    >enter the date on which the incident occurred, could I
    >then request the program to sort this data into
    >chronological order?

    Certainly; you would enter the data (using a Form as a data entry
    tool) into an Access Table - the data repository for everything you do
    in Access. You could then have a Query sorting chronologically (and a
    different query sorting alphabetically by the name of the employee,
    and a third query sorting by criticality, if those are desired). Once
    you have the data in a table you can slice and dice it pretty much any
    way you like.

    >I would then want to expand on each
    >piece of data by providing more details on each
    >incident.

    This would be a second Table, related one-to-many to your first table.
    Again, a Form (based on the first table) with a Subform based on the
    second table would be handy to enter the data.

    >Upon completion, I would then want to print
    >out all this data, thereby having a complete set of
    >chronological documentation

    An Access Report could easily be built to do this.

    In short... Yes. Access is a good tool to do all that you ask.

                      John W. Vinson[MVP]
        Come for live chats every Tuesday and Thursday
    http://go.compuserve.com/msdevapps?loc=us&access=public

  • Next message: John Vinson: "Re: search query by date"