Group by and sum in access

[nickom]

Hi,

I am attempting to calculate the total value of a field in an access database but I am having problems getting my head around the way to achieve it,

I have a set of data that is identified by a record called a faultreference#, because the faultreference# can appear more than once, as the fault is broken down into its individual items with a cost asigned to each item.

I would like to group on the faultreference# and apply a sum of the costs, this works fine, but because the group by is applied to all referred to data items, when a unique value such as ID is included in the query the grouping breaks down, I suppose the simple answer is don't include the ID field, but I would like to use a sub form that pulls in other data such as contacteddate and edit it when I review the summed data, thereby needing ID to refer back to the relevant agregated field.


Really appreciate any help given on this
Thanks
Nick

PS All the data is in 1 table, to make weekly imports of data easier in to the DB

[MMcCarthy]

It's very hard to give any advice on this as you have used one table which restricts what you can query. Have a lot at this tutorial on how to break down the table.

Database Normalization

You can still import the data to one file and then append it to the relevant tables accordingly.