sandhurstUK
Must change my user name
- Local time
- Today, 19:15
- Joined
- Feb 15, 2002
- Messages
- 42
I know there must be a simple solution to this, but I have been pulling out what little hair I have left for two days now.
I am fairly new to databases so please be gentle with me !!
Problem: I have a qry which runs fine against a table and shows all the entries (around 1000 rows of data), however, there are many records where for example the name or address or the post code (zip code) are the same. Each record has a field which shows a value for the amount of hours work due for each record.
What I want to do is to group together all records which have say the same address and sum the total hours work for each.
Any help would be immensly appreciated.
I am fairly new to databases so please be gentle with me !!
Problem: I have a qry which runs fine against a table and shows all the entries (around 1000 rows of data), however, there are many records where for example the name or address or the post code (zip code) are the same. Each record has a field which shows a value for the amount of hours work due for each record.
What I want to do is to group together all records which have say the same address and sum the total hours work for each.
Any help would be immensly appreciated.