Hi,



I have spread over four tables survey information our company has gathered 

from particular clients. Each table has approximately 40-50 Yes/No Data 

types. We are expecting to have about 300-400 entries. I am running 

Access2K.



My question is if there is a more efficent way of storing and quering such 

data. At the moment, for querying I simply do "FocusAD.BizComp = Yes AND 

FocusAD.BizFinance = YES AND FocusEO.Marketing = Yes" and so on, and so 

on. With over 40-50 Yes/No Data types for each table, the SQL coding for 

the query on all four tables can get quite long. Note, that the query 

checks to see if the field is a "Yes" never a "No".



Thanks a Lot,



Daniel

I have had the same issue when writing queries with extensive criteria.

I did a program for a company renting apartments and there were a huge

number of fields a prospective tenant filled out and the equivalent

fields for each property. Looking for matches was a nightmare. But it

works even though it takes a lot of time writing the code. So the bottom

line is from my experience you are on the right track and I don't know

of any more efficient method. Would like to see some other replies with

any new ideas.

Richard Lobel

Here is the text of a message sent earlier on this list--perhaps the

referenced database would be a good example to follow?



HTH,



-Roy



> -----Original Message-----

> From: Bob Bedell [mailto:bdbedell@m...]

> Sent: Saturday, June 23, 2001 4:07 PM

> To: Access

> Subject: [access] Re: Survey Form

> 

> 

> Ya' gotta' check out Duane Hookom's fabulous survey definition 

> and reporting application at 

> rogersaccesslibrary.com/duanehookom/duanehookom.htm. Best open 

> source code "sample" Access app I ever came across. The app is 

> called At Your Survey (ATS) and you can download it for free. But 

> as Duane says, "Steal ideas and methods but not the whole of the 

> application." In other words, you can't distribute it. See what 

> ya' think.

> 

> >From: "niraj sharma" <nsharma@y...>

> >Reply-To: "Access" <access@p...>

> >To: "Access" <access@p...>

> >Subject: [access] Survey Form

> >Date: Sat, 23 Jun 2001 17:09:11

> >

> >I am trying to design a survey with about 100 questions.

> >I would like to break the survey down into 10 pages of

> >10 questions each and have a continue button at the bottom

> >of each page. Finally, I would like to insert the results

> >into the database. I would also like for the user to be able

> >to go back to previous questions while retaining their

> >answers so they can make changes if necessary

> >

> >Anyone worked on a similar project?? If so, I would appreciate

> >your help...







-----Original Message-----

From: Daniel Riveong [mailto:daniel@e...]

Sent: Monday, July 30, 2001 7:32 PM

To: Access

Subject: [access] More Efficent Method of Storing Survey Data?





Hi,



I have spread over four tables survey information our company has gathered 

from particular clients. Each table has approximately 40-50 Yes/No Data 

types. We are expecting to have about 300-400 entries. I am running 

Access2K.



My question is if there is a more efficent way of storing and quering such 

data. At the moment, for querying I simply do "FocusAD.BizComp = Yes AND 

FocusAD.BizFinance = YES AND FocusEO.Marketing = Yes" and so on, and so 

on. With over 40-50 Yes/No Data types for each table, the SQL coding for 

the query on all four tables can get quite long. Note, that the query 

checks to see if the field is a "Yes" never a "No".



Thanks a Lot,



Daniel

---