Hide Duplicate Record

[razchip]

I have a form that may have the same Item# with different bits of information four or five times on the screen. The users are asking if Item# can be hide for the 2nd through 4th records.

4078 070707 3,657
4078 070807 4,697
4078 071007 952
4078 071107 6,843

The users would like to see only the first 4078 if possible.

I've had no luck with anything I've tried, thanks for any ideas.

Thanks for the help.
Greg

 

[missinglinq]

Crank up Access Help and type in Prevent duplicate records from displaying

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[maxhugen]

As the query behind your form is returning non-DISTINCT data, you could try a Grouping query that returns the First value only, eg:

[tt]SELECT itemNo,
First(itemDate) AS firstItemDate,
First(itemVal) AS firstItemVal
FROM item
GROUP BY itemNo;[/tt]

Of course you'll need to change the table and field names appropriately first.

Max Hugen
Australia

 

[TheAceMan1]

. . . or a mainform based on the Item# with linking subform holding the rest . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884: