Search results

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

Thank you, it's mainly the normalisation that I need to learn about, so will have a read though and see how I can apply the concepts to this db. The query as I wrote it gave me this output Which matches up with data actually in the table. Don't ask why Thursday is the only day not abbreviated...

Thank you, this chimes with what MarkK wrote and i've tested and it gives me the count I need. So would that second bit be: select chkbox1, chckbox2, chckbox3, chkbox4, chkbox5, count(*) from table group by chkbox1, chckbox2, chckbox3, chkbox4, chkbox5 or have I misunderstood?

I do now, yes. As mentioned above this was dropped on me very late and the original database has evolved(for want of a more derogatory term) over 25 years to the state it is in now. As an example of that state I just did ? CurrentDb.TableDefs("tblFoo").RecordCount on the main table and it has...

You sir, are a star, this answers the first part of the question perfectly, thank you! I think I'm going to abandon the idea of the second point, I might shove the data into Excel and mangle it that way if it's REALLY needed by the end user.

As mentioned above - appreciate that the structure is not ideal, but there just isn't enough time for me to rewrite the whole thing at this late stage. The link is interesting but to do what I want to do with that method wouldn't it require going to each record in a form rather than a query I...

Oh right, I understand, and I understand how it *should* be, unfortunately I inherited this database from someone who used it like a flatfile so basically everything is in one table. To give you an idea this thing was originally written for Access 97, when that version was new. I should say...

Sorry, I've just realised by post was unclear, the name and the checkboxes are not the only fields in that table, there are fields such as contact info for each individual who has signed up as well. The count of number of days signed up for (the first part of the question) is so that each...

Hi I have a table that has a (text) name field and five checkbox fields in it (representing days of the week Mon-Fri), which is part of a class booking system where people can pick which day(s) they want to attend. I need a way of counting the number of checkboxes each record has ticked in two...