date selections from one table to another

[Schon]

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??

 

[Duane Hookom]

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];