G
Guest
Greetings all. I have a query containing fields of numbers of households
engineered which come from one table. For example, there is a field for
single family units (SFU), multiple dwelling untits (MDU), and commercial
units (CU). For one record there might be 100 SFU, 50 MDU, and 10 CU. I
want to add a column in my query to total the quantity in each field for
every record. I tried using the expression builder, but it does not work for
most of the records. I do not know how to write code, so I am limited to the
query tools. Is there something I am leaving out? I want it to look
something like this:
SFU MDU CU Total
100 50 10 160
200 40 20 260
Is this possible? I could not find anything helpful in past posts that did
not entail writing code I did not understand. Thank you in advance.
engineered which come from one table. For example, there is a field for
single family units (SFU), multiple dwelling untits (MDU), and commercial
units (CU). For one record there might be 100 SFU, 50 MDU, and 10 CU. I
want to add a column in my query to total the quantity in each field for
every record. I tried using the expression builder, but it does not work for
most of the records. I do not know how to write code, so I am limited to the
query tools. Is there something I am leaving out? I want it to look
something like this:
SFU MDU CU Total
100 50 10 160
200 40 20 260
Is this possible? I could not find anything helpful in past posts that did
not entail writing code I did not understand. Thank you in advance.