HELP - Llinking Tables by Date

[philljo]

Hi Guys,
I'm doing this really complicated Query and am Totally Stuck.

In one table I have various Dates with Various Data. In another table i have Fields with "from date" and "to date", I link them with one field but also want to link if the date in table 1 falls between the From and To dates fields in Table 2.

Thanks

 

[Joe4]

Just link on your one linking field, then add criteria for the date portion (instead of trying to link on those date fields).

So, in your query, under the Date field from Table 1 add criteria similar to this:

Between [Table2].[FromDate] And [Table2].[ToDate]