Migrated a 2003 Access database to SQL server, with Access as front end.
The original Access has a query built by joining two tables.
Tabl1.ColA,Table1.ColB,Table2.Id,Table2.Desc.
The query results are always displayed in a editable datasheet view, based on date ranges entered on the form...