I do understand the lessons about string concatenation and about a calculated query field. But I still fail to see how I can use a ticked option box in a calculated query field.

---

Reply from Richard Rost:

Use combo boxes to select values, and assign each of those values a character. For example, let's say you're picking a color and size:

ColorT
R, Red
B, Blue
G, Green
K, Black

SizeT
S, Small
M, Medium
L, Large

Now have two combo boxes where you pick a color and a size. The values in those combo boxes (and the underlying fields, if you bind them) would be:

R, S
G, L
R, S
etc.

Now just use a calculated field in a query to merge them together with concatenation, and you get:

RS
GL
RS

Does that make sense now?