In Access 2000 I have two tables, table1 & table2 table1 contains the fields: Id, RecordingId, RecordingDate table2 contains the fields: FirstRecordingDate, LastRecordingDate I want to run a totals query that shows me the sum of RecordingId in table1, between FirstRecordingDate & LastRecordingDate in table2 How do I do this?
Group Records in one table based on records in another table
- Thread starter TimTDP
- Start date
