Linking date fields from unrelated tables

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

Guest

Hi guys,

Hope you can help.

I have to create a query using three different and totally unrelated tables.
All tables, however, have a date field. I was thinking if it was possible to
have a criteria linking the content of the three tables according to a date.

Example:
table1: dateofentry
table2: dateofsale
table3: dateofdestruction

I wanted to set a criteria "Between [bla] and [and]" to display all the
content of all tables of which the date fields would fall in the parameter.

Thanks in advance!

Tiago.
 
Hi Tiago,
Your idea to link via date is difficult to assess but I would guess that it
is unlikely to work, because the dates are not likely to have a relationship.
Instead, you could create either a Union Query where you force data into one
query from different sources. There are lots of examples of this around
Access Help, alternatively build a link table to forge relational joins
between the three tables. You need to find like many fields and cross link
them. Provide more detail and I will see if I can help.

GarryD
 
Back
Top