I tried creating the query again using the query wizard and I did not see the option to "select duplicate values".
I did find the option to omit duplicates by going into Properties for the query and selecting "Yes" for Unique Values, but that is not what I want.
Let me know if I'm looking in...
I have created an Access 2003 database that stores all of our software licenses. With Microsoft Open Licenses, many of the License Agreement Numbers are the same and I would like to list them in a query.
How do I create a Access Query that will list only the records that have duplicate...
I have created a Software License database to keep track of software licenses. It includes a table-based combo box named "Software". The table associated with "Software" is named "Software List", and it's two fields are named "SoftwareID" and "SoftwareList". The "SoftwareList" field stores the...
I have created an Access database that stores Software Licenses for my company. As I view each software license and its quantity in “Form View”, I would like to see the current total number of licenses for that particular license. Using Project 2000 as an example, if I'm viewing a Microsoft...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.