|
View Full Version : Group Records in one table based on records in another table TimTDP 10-25-2008, 11:47 PM 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? Uncle Gizmo 10-25-2008, 11:57 PM Is there any common linking data between the tables? TimTDP 10-26-2008, 12:32 AM No there is not Uncle Gizmo 10-26-2008, 12:39 AM How many rows are there in table 2? TimTDP 10-26-2008, 12:44 AM about 10000 Uncle Gizmo 10-26-2008, 05:35 AM Try this ................. |