Counting trailer numbers

  • Thread starter Thread starter Dragon
  • Start date Start date
D

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
 
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
 
Can I use it from within the query? It needs to be easily imported into a
report / subreport.

Dragon

Golfinray said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top