Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to link several tables in Access to one item (date)?

Discussion in 'Information Technology' started by Confused, Jul 28, 2006.

  1. Confused

    Confused
    Expand Collapse
    Guest

    Help I am trying to put together a summary report that includes many factors.
    I have created several tables to help seperate each topic but I do not know
    how to link each table with a entry of the date on a form. This is my first
    time using access. I am not using excel because this data will be used in
    many different ways and an infinite amount of data needs to be stored.
     
  2. Loading...

    Similar Threads Forum Date
    Eh Janam Tumhare Lekhe... Official Movie Link... Announcements Jun 3, 2015
    Sikhism Complete Shalok Mehala 9 (Link) Videos Apr 22, 2014
    UK British PM orders probe into Thatcher link to Operation Bluestar (UPDATED) Breaking News Jan 14, 2014
    India Gwalior: A Unique Link to India's History Breaking News Nov 16, 2013
    Researchers establish link between racism and stupidity General Sep 28, 2013

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Thu, 15 Jun 2006 10:31:05 -0700, Confused
    <Confused@discussions.microsoft.com> wrote:

    >Help I am trying to put together a summary report that includes many factors.
    > I have created several tables to help seperate each topic but I do not know
    >how to link each table with a entry of the date on a form. This is my first
    >time using access. I am not using excel because this data will be used in
    >many different ways and an infinite amount of data needs to be stored.


    Base the Report on a Query, using

    =Forms![NameOfTheForm]![NameOfTheTextbox]

    as a criterion on the date field.

    How you would relate your tables in the query depends on the structure
    of those tables - which I do not know, of course!

    John W. Vinson[MVP]
     

Share This Page