Hello, I am very new to Access and self taught by YouTube / Google and by no means a "computer" person. My apologies if I am therefore using incorrect terminology.
I have a query that pulls info from a main order form and its sub form with the item details. I have totals on the main order that I would like to show up only once in my query, while still displaying the information of each item. I have gotten this idea to work on a report I created based on the query by highlighting the text boxes for the data I did not want to repeat and clicking yes on the hide duplicates within the property sheet.
I am assuming this can not be done in a query, but as I said I do not actually know that much about Access yet, and have been surprised a few times at what is possible. I am doing most of my work in design view and have just barley started to dabble in macro functions. If it is possible and anyone knows a good reference article or YouTube video on how to accomplish this I would greatly appreciate it! Or just let me know its impossible so I can stop looking (:
Thank you!