Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Questionnaire Database structure & Data Entry Forms
The application isn't a survey, although it is similar to a question and answer type document. It's a record of each machine built. There are stations the machine passes through. Each station has "questions" to collect data on different aspects of the process. Some portions require storage...- larai
- Post #7
- Forum: Microsoft: Access Other topics
-
Questionnaire Database structure & Data Entry Forms
What about objects and memo fields? And what would the purpose of the datatype identifier field be? Thanks!- larai
- Post #5
- Forum: Microsoft: Access Other topics
-
Questionnaire Database structure & Data Entry Forms
Wow, impressive application. It appears as though rather than splitting your answers into different tables depending on the datatype that you are storing all responses in 255 char text fields. Is that preferable than using different tables that each contain answers of different datatypes...- larai
- Post #3
- Forum: Microsoft: Access Other topics
-
Questionnaire Database structure & Data Entry Forms
I've been looking through the forums and came across this thread, which I read through thread705-844594. I found mention of possible alternatives if there are different data types required in the answers. My question relates to how to manage the different datatypes. I have boolean, integers...- larai
- Thread
- Replies: 7
- Forum: Microsoft: Access Other topics
