How do add records from one table to another

[barcode711]

I'm working on this db for school..i need help!

I have one table called "Daily Traffic Stops" and another one called "Monthly Traffic Stops". All I need is to figure out how to add each record from "Daily Traffic Stops" to the table "Monthly Traffic Stops" automatically, so it will tally up the "daily traffic stops" by month.

If I'm not making myself clear, I can explain more...thanks!

 

[barcode711]

Ok, this is supposed to be a db that records traffic stop info such as how many females,males, age ranges, etc. were stopped each month.

I have a table called "Daily Traffic Stops" where each record contains all traffic violations for that day.
Example: Record 1 = January 1, Record 2= January 2, etc.

Then I have another table, called Monthly Traffic stops, where each record contains data for a month.
Example: Record 1 = January, Record 2=February, etc. Then each month we would print out a report containing all the data, or at the end of the year I could compile all the months together to create an annual report.

Perhaps this is where I'm not thinking clearly. I'm sure there is a better way to do it.

 

[jwalt]

I think you only need one daily table and use reports to pull the data for the time periods you need....build your queries behind the report in design view and include a criteria "where" like this

criteria [enter beginning date]and[enter ending date]

this way you can pull the data for the time period you want and then in the report you can summarize it and use calculated controls to give you the totals.

john walters