Distinct Issue

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

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;
 
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.
Click to expand...

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).
 
Back
Top