Counting trailer numbers

[Dragon]

I have four checkboxes in a table tracking types of loads shipped.
I need a query that can tell me the number of loads of each type shipped in
a given day.
The loads can be export or not, and within export it could be a truck,
railcar or container. If the load is not an export load, it is always a
truck. Also, when there are no records (i.e. no containers loaded that day)
there needs to be a default value of zero. This way the number of records
the query returns is consistent.

Example of quantity output for a given day:

Trucks loaded domestic: 0
Trucks loaded export: 1
Railcars loaded export: 3
Containers loaded export: 0

Thanks in advance,
Dragon

 

[Golfinray]

If you use a form, use the count command. Put a textbox on the form in the
form footer and make the control source =count([checkbox1]), =
count([checkbox2]), etc

 

[Dragon]

Can I use it from within the query? It needs to be easily imported into a
report / subreport.

Dragon

If you use a form, use the count command. Put a textbox on the form in the
form footer and make the control source =count([checkbox1]), =
count([checkbox2]), etc

I have four checkboxes in a table tracking types of loads shipped.
I need a query that can tell me the number of loads of each type shipped in
a given day.
The loads can be export or not, and within export it could be a truck,
railcar or container. If the load is not an export load, it is always a
truck. Also, when there are no records (i.e. no containers loaded that day)
there needs to be a default value of zero. This way the number of records
the query returns is consistent.

Example of quantity output for a given day:

Trucks loaded domestic: 0
Trucks loaded export: 1
Railcars loaded export: 3
Containers loaded export: 0

Thanks in advance,
Dragon