If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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?? |
#2
|
|||
|
|||
date selections from one table to another
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?? |
Thread Tools | |
Display Modes | |
|
|