query on checkbox doesn't works

[kitaeshi]

hi all i have a problem with access checkbox.

Data is name & 5 checkbox which is mon, tue, wed, thu, fri

User will access a form which have 5 checkbox mon, tue, wed, thu, fri..
The user will check the box & press enter, the input will pass on to a form to display out the name which have the checkbox checked.

i based on my previous query using a dropdown box which is [forms]![checkform]![checkmon] to query out the value

but nothing is display..so i suspect the problem lies with the synax of the query...so can someone guide me how to solve the problem so that i can advance to the next step.

Thanks ya.

 

[kitaeshi]

anyone know how to solve my query?

Tks ya.

 

[boblarson]

Sorry if this sounds flippant but "redesign your table so it is normalized." That is the best way to deal with it.

 

[kitaeshi]

Hi boblarson, how do u redesign the table? coz i think the problems lies on the query part...if i can get the query part right, my problem will be solve ^.^

 

[boblarson]

For this one, if you leave it as is, will require 5 queries joined as a Union query in order to get all days output.

Since I don't know what your whole data structure is I can't give you a whole lot of design help. With more information on your current table structure and what you are trying to accomplish, we might be able to supply more help in that area.

 

[kitaeshi]

hi tks. below is the link
http://www.sana.org.sg/chris/test6.mdb

There are 3 form inside,
check - the form to select the days
name - to display out the days selected
input - to manual select which user are free on which days.

 

[kitaeshi]

so anyone know how to solve my problem?