Distinct Issue

[Rpettis31]

I am trying to query an item and would like to see all the notes associate
with an item, but I do not want to list the item on every row.

Item A - Note 1
- Note 2
-Note 3
here is my SQL
SELECT DISTINCT tblItemRecords.Item, tblItemRecords.Description,
tblOptionGroup.OptionNameGroup, tblItemRecords.Owner, tblInvNotes.Date,
tblInvNotes.Notes
FROM (tblOptionGroup INNER JOIN tblItemRecords ON tblOptionGroup.OptionGroup
= tblItemRecords.ItemDispo) INNER JOIN tblInvNotes ON tblItemRecords.Item =
tblInvNotes.Item;

 

[vanderghast]

Use a report?


Vanderghast, Access MVP

 

[John W. Vinson]

I am trying to query an item and would like to see all the notes associate
with an item, but I do not want to list the item on every row.

Then use a Form based on the items table, and a Subform based on the notes
table. You can't do what you ask in a Query (but then you shouldn't be using
query datasheets for displaying or editing data in any case, that's not their
function).