Hi Carol
What that plus sign indicates is a sub data sheet. I usually avoid them like the plague but MS thought some people would find them useful
Check out the info at https://support.microsoft.com/en-us/office/add-a-subdatasheet-900d1d30-5ea2-4e47-80a7-ddcb87a53d14
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
MS Access MVP 2006-2016
My Nothing-to-do-with-Access blog
From: MSAccessProfessionals@groups.io [mailto:MSAccessProfessionals@groups.io] On Behalf Of cash.ghwa@gmail.com
Sent: Saturday, March 27, 2021 3:14 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: [MSAccessProfessionals] Access 2006 Simple question
Hi.
Seems the only time I ask a question is when I have a senior moment. I wrote a basic query years ago.. When I get my results, I somehow connected the result records back to the main database. They can be displayed by clicking on the "+" that shows up to the left of the record. How did I do that? I tried creating a new query but can not get it. The original one has the query "related" to the main database by the "Itemnbr ".
The main database (stripped down version) contains: itemnbr, description, cost, sell, purchasedate, selldate. Nothing fancy. The query table only contains: itemnbr, selldate. When I run the query I can click on the result record by using the "+" to recall more details about the item if needed.
Simple!! Not anymore…… HELP!
I have another senior moment issue, but can wait on than one….I'll try figuring it out for a bit longer before I give up.
Thank you.
Carol Higbee
Sent from Mail for Windows 10
Tidak ada komentar:
Posting Komentar