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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Updating tables when you input new data 0
How to export table from outlook into ms access table? 0
Import XML to Access ... 4
Changing a Table to a Linked Table? 4
Change one table link by vba 1
Linking tables from existing data 1
How to link a Access FE to SQL Server BE 10
Linked Table Security in MS Access 4

Back
Top