Group by Field on the Form link to the table

B

Bill

Hi,

The table has four fields
Sport (field1)
Team (Field2)
Last Name (Field3)
Game Schedule (Field4).

Table show like this:
Hockey Boston Smith May 12, 2006
Hockey Boston Flower May 12, 2006

Right now, I see on the form linking to the Table
Hockey Boston May 12, 2006 (no last name)
Hockey Boston May 12, 2006 (no last name)
Hockey Florida Blank Date
Hockey Florida Blank Date

I want to see this only one line on the form instead of two line on the form
:

Hockey Boston May 12, 2006 (no name)
Hockey Florida blank date (no name)
I know how to group it on the query and reports. I 'm trying to group it
in the form instead of using query and report.

Your help would be much appreciated.
 
T

Tracy

Bill, In the forms record source copy in the following:

SELECT Table1.Field1, Table1.Field2, Table1.Field3
FROM Table1
GROUP BY Table1.Field1, Table1.Field2, Table1.Field3
ORDER BY Table1.Field1;

If that doesn't work for you - I don't know... Good luck!

Tracy
 
Top