Hi there,
I am looking for the way to represent data with the similar column
value to one row.
A query retrieves 3 records AS IS, but I need one record.
Thanks, for your help

Table:
Name / 1 year / 2 year /3 year

AS IS

Name 1 year 2 year 3 year

1 John Smith A
2 John Smith B
3 John Smith A+
=================================

TO BE

Name 1 year 2 year 3 year

1 John Smith A A+ B

Alex aalkor wrote:

See
Concatenate fields in same table
http://www.mvps.org/access/modules/mdl0008.htm

That answers your question, however if your design was normalized, you
have an easier time with querying the data.

Alex aalkor wrote:

See
Concatenate fields in same table
http://www.mvps.org/access/modules/mdl0008.htm

That answers your question, however if your design was normalized, you
have an easier time with querying the data.

Alex aalkor wrote:
A simple grouping query would seem to be the answer here ...
Wait.
Are those numbers (1,2 and 3) a separate column in the table? Or are these
three different names in these three records? "1 John Smith", "2 John Smith"
and "3 John Smith"?

If the numbers are actually in a separate field, then the grouping query is
the answer:

select name, max([1 year]) As Year1, max([2 year]) As Year2, max([3 year])
As Year3
from tablename
group by name

If the numbers are part of the name, then you're going to need to tell us if
they are consistent. Do they always consist of a number followed by a space
and then a name? Or are there other formats we need to worry about? Also, if
similar does not mean "exactly the same" to you, you need to show us some
names that are not exactly the same yet need to be treated as "similar".