Attachment 185Hi

I have a issue..
my database allows me to select two dates: startdate and enddate.
once i have selected the dates, it opens a form.
When I select the customized dates, say for ex 7-nov-08 to 8-nov-08, I would like to merge the information of these dates together like:
For 1 IP address, I wish to merge totalports, upPorts, DownPorts for all these 2 days (7th and 8th nov)

like merge 10.0.36.1
merge 10.0.36.11
merge 10.0.36.2
================================================== ====


I have attached the file of the form. The circles have been marked to show exactly what has to be merged.

I have a hint that I have to use group by syntax in sql in my query but not sure.
Kindly guide me how to merge them in MS Access.
Thanks and best regards,
Shruti