Is it Logical?

[Demona]

Hi guys,

I just want to know if I was getting over my head(or just plain crazy) with this form that I am doing. I want to build a query 'on the fly' sort of speak (forgive my slang). I have a form that is filled with check boxes that a user selects what information he wants to query and from that query a report is generated. Is this a bit much? Can anyone suggest a better way to attack this problem? Keep in mind that the form is going to contain between 20 and 40 check boxes and a Start / End Date Text box.

Any suggestions on how a person could attack this better would be appreciated.

Thanks

Love and Kisss

Demona

 

[FoFa]

Would it be possible to paramatize your query, and supply the parameters based on your check boxes?
20 - 40, are you sure it is designed correctly? You typically don't have that many options to report on. Could you break the report up into different reports and cut back on your options some? You aren't just over zealouse trying to give them too much flexability are you? It is also possible to generate the SQL "on the fly" in VBA, but I suspect you would run into the string length limit pretty quickly with that many options.

 

[dcx693]

As FoFa replied, it probably is possible, but 20-40 choices is a lot. To handle all those cases, you'd need to generate the SQL on the fly. It's a very good technique to learn and use, but not Access 101 stuff.

 

[Demona]

hummm ... you may be right.

Thats why I just wanted to know whether or not I was nuts or not.. Would it be better to have the queries already built and then combine them with check boxes so that a combination of information can be looked at?

Thanks

Love and Kisses

Demona

 

[Mile-O]

I think it might be better to look at your table structure first before you get into a long-winded query building process.

Describe your table(s)

 

[Demona]

Table in Excel Format

Here Mile-O ... I exported it out into a excel sheet. This should give you a rough idea of what I need to query.

Things like Shift ID - there's 4 shifts (ABCD) so that has to be queried.

Reasons for example change depending on the area and sub area and also whether or not it is E M O.

There are a lot of variables ... this is why I asked this question before I get carried away and can't get myself out of a pickle.

Thanks

Love and Kisses

Demona

 

[Mile-O]

Is that representation just one table in your database?

 

[Demona]

Yes that is the main output table. All data is placed in there.