date selections from one table to another

Is there a way I can have table1 with only 2 fields (Begin Date) and (End
Date) and have a query that asks for all the records from table2 where field
(Date of Service) is between (Begin Date) and (End Date) from Table1??

If so, how??

The query won't be updateable but you could try:

SELECT Table2.*
FROM Table2, Table1
WHERE Table2.[Date Of Service] BETWEEN Table1.[Begin Date] And Table1.[End
Date];


--
Duane Hookom
Microsoft Access MVP


"Schon" wrote:

Is there a way I can have table1 with only 2 fields (Begin Date) and (End
Date) and have a query that asks for all the records from table2 where field
(Date of Service) is between (Begin Date) and (End Date) from Table1??

If so, how??