Linking date fields from unrelated tables

[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.

 

[Guest]

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