Is this possible in query and if so how??

[andy_dyer]

I have two task names within my database that I want to check if they exist together for the same project to merge them together into a new task totalling their estimated and actual hours booked against them...

"WP0 - Project Management"
"WP0.1 - SPM Supervision"

New Task: "Project Management"

Can this be done??

If so any pointers gratefully received...

 

[Brianwarnock]

Do I presume that the project code in the example is WPO and are all project codes 3 letters?
If so I think a Totals query Grouping on Left(fieldname,3) will give you your data, select Sum, First or whatever is nescessary to gather other data into 1 record.

Brian

 

[andy_dyer]

Do I presume that the project code in the example is WPO and are all project codes 3 letters?
If so I think a Totals query Grouping on Left(fieldname,3) will give you your data, select Sum, First or whatever is nescessary to gather other data into 1 record.

Brian

Thanks Brian that did work...

Thanks for your help!!