Query by form problem

[abujafar]

hello every one. I am trying to specify more than one criteria using or on a textbox using query by form. This is pretty urgent.

database facts:

There are six periods in the school year. I have a checkbox for each period. Whenever a checkbox is clicked that period is added to the textbox. If only one checkbox is selected then one period is added to the textbox and the query works.

e.g. 1

however if more than 1 checkbox is chosen I add the next period using or:

ex: 1 or 2

in this case the query does not work. Anyone have any idea why.

I need the user to be able to select more than 1 period on the from for attendance reports because parents can request attendance reports for one or more periods at a time. thanks in advance for you assistance.

 

[John Big Booty]

Any chance of posting a copy of your DB?

 

[abujafar]

Here is a copy of a similar database. I can't upload the original so I recreated the problem in a simpler database.

Thanks in advance

 

[John Big Booty]

Whilst I'm trying to get my head around this, have a read up on normalisation. That's the first thing I thought when I opened the DB you posted.

 

[John Big Booty]

OK I see what you are trying to do. The problem is that once you have more than one selection the query is recognising the text box as a string rather than a number of integers separated by "Or" statements. This is why you are getting no match for multiple selections.

I'm sure there is a way around this but I've not yet figured it out

 

[abujafar]

I am still having problems with this issue. I am seeking an alternative solutions. Anyone knows how to use the IN keyword in Access in Design view. "Not SQL view"