SELECT Count([Table1].ItemID) AS ItemCount, Count([Table1].ModelID) AS ModelCount, [Table1].LocationID FROM (SELECT DISTINCT [Table1].LocationID FROM [Table1] );
|Contents of subform based upon combobox value||3||26|
|Access importing CSV that has commas in currency and needs 2 cols formated for numbers to text||5||33|
|Web based Access Database and licencing||5||29|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!