My problem: I am using ACCESS2010. I need to count the number of specific parts ( 1 – 10 ) in INVENTORY from 5 regions of the country. The date range needs to be the past 90 days. Each region is a separate table and PART field. The fields are all identical. I need to GROUP the count on specific part #’s Say, PART 1 – PART 10 and obtain 1 COUNT of parts 1-10.
MAIN issue. I have successfully grouped region 1 separately and got the correct count. Individually each FIELD GROUP [Region1] [COUNT] works fine. My problem is that I have not been able to successfully figure out how to add all 5 regions together and obtain an accurate combined count of all regions. I looked at every Youtube video and reviewed lots of COUNT examples. I have a number of ACCESS books - Nothing tells me how to combine (GROUP) 5 fields of DATA together and obtain one accurate count of all 5 REGIONS. I understand a fair amount of basic SQL. So, if that’s what you send me I can use it. Any help greatly appreciated. PS, I’ve successfully accomplished this in Excel. Any help greatly appreciated.
Regards,
Michael