repeting values in group by clause

[Waqas ali]

I have one query. I calculated some columns by aggregate sum function. In one column i want to get only one value instead of repeting again and again.

A 6 8 Ahmad
A 7 9 ali
A 4 2 tariq

I want to see A one time with first value.

 

[Joe4]

I want to see A one time with first value.

You need to define what you mean by "first" value, in database terms. Can you sort by some field that the value you want will always be the "first" one?
If you have an Autonumber field, that often will serve the purpose.

 

[Waqas ali]

A 6 8 Ahmad
7 9 ali
4 2 tariq
I want in this way via query A should be appear one time only.

 

[Joe4]

You can create an Aggregate Query, to identify a single record for each group, and link that back to your original table, and then you could suppress it on the succeeding records. But as I mentioned in my first response, we need to determine how exactly you will be ordering the records, so we know which field and Aggregate function to use.

So feel free to take a crack at it. If you want more help on it, you will need to answer the question I answered above as well as telling us the table and key field names (the name of the field the "A" appears in, as well as the name of the field we will be using in the Aggregate Query).