Avatar of bnemmers
Flag for United States of America

asked on 

Count number of Widgets accross 4 tables

Hello Experts,

I have 5 tables, table 1 is a list of building numbers, about 1000 records and the other 4 tables are list widget types in the buildings. I'm  trying to create a query that will list by row the; building IDs, widget_1_count, widget_2_count, widget_3_count, widget_4_count. If the Building_ID count is zero I'd still like to list it in the results as zeros across all four fields

I’m using MS Access 2013

Thanks in advance
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon