Solved Counting multiple checkboxes (1 Viewer)

[June7]

And if you want to calculate a text label for each row, consider:

IIf([in_mon]=-1,"M","") & IIf([in_tue]=-1,"T","") & IIf([in_wed]=-1,"W","") & IIf([in_thursday]=-1,"Th","") & IIf([in_fr]=-1,"F","") AS Days

This expression would be repeated in the GROUP BY clause.

@MarkK, How did you get the "Copy to clipboard" button in formatted text?

 

[CJ_London]

or have I misunderstood?

No, that is what I meant - was on my phone so couldn't really write example

 

[KitaYama]

I think I need to read up on bitmask/bitmath to understand this to be honest, thank you for the additional idea though.

Using Bitwise Operators In VB

To demonstrate bitwise concepts, this article shows you how to store an array of Boolean flags within a single numeric variable.

www.jameshbyrd.com

And @theDBguy shows how to use it in a query

Bitwise Operation in an Access Query

Let me preface this article by saying this is not a topic I am really familiar with. I only decided to write it to share an experience I had...

thedbguy.blogspot.com

 

[MarkK]

@MarkK, How did you get the "Copy to clipboard" button in formatted text?

@June7 I don't understand what you mean, like, what dah what what? Formatted text? Copy to Clipboard? I must have missed something.
Mark

 

[June7]

In your posts. As in Post #9. The formatted code example has a "Copy to clipboard" button.

 

[KitaYama]

@June7 Do you mean like this?
I simply selected code from toolbar while replying.

test code

 

[Gasman]

In your posts. As in Post #9. The formatted code example has a "Copy to clipboard" button.

@June7 The site does that? Here is MarkK's code copied using that button.

SELECT FirstName & ' ' & Lastname As Fullname,  -IsMonday - IsTuesday - IsWednesday - IsThursday - IsFriday As WeekdayCount
FROM YourTable

 

[June7]

Really? I thought I tried the CODE icon. Will have to try again. Thanks.

 

[Gasman]

Really? I thought I tried the CODE icon. Will have to try again. Thanks.

SELECT FirstName & ' ' & Lastname As Fullname,  -IsMonday - IsTuesday - IsWednesday - IsThursday - IsFriday As WeekdayCount
FROM YourTable

I rarely use the code icon, preferring to type code and /code (surrounded by [ & ]) manually. Just tried with the icon General Code though, and that produced the above?