I have a query, "tripsupplies", that has 5 fields. (catagory, item, bike1, bike2, thistrip).
That query, produces a 'check list' report that outputs all the items needed for bike1 and a different report for bike2.
Both reports (bike1 & bike2) list every item per bike fine. However, now I would like to have a report that produces only certain items, (items I select from the yes/no data type from the 'tripsupplies' query). I do not want all the items for a particular bike to show up, rather the items I want from the 'thistrip' field.
Example: if bike1 has 50 items listed in a check list report, yet I only want to produce a check list that produces only 10 items from bike1.
How would I do this?
I tend to think this is simple, but now my brain is wiped out!!!
If I need to explain further I will...
TIA
c
That query, produces a 'check list' report that outputs all the items needed for bike1 and a different report for bike2.
Both reports (bike1 & bike2) list every item per bike fine. However, now I would like to have a report that produces only certain items, (items I select from the yes/no data type from the 'tripsupplies' query). I do not want all the items for a particular bike to show up, rather the items I want from the 'thistrip' field.
Example: if bike1 has 50 items listed in a check list report, yet I only want to produce a check list that produces only 10 items from bike1.
How would I do this?
I tend to think this is simple, but now my brain is wiped out!!!
If I need to explain further I will...
TIA
c
