Recent content by trolleri

For clarification: -- My project: -- Approximately 200 patients are going to answer more than 900 questions split out on different questionaries they get handed out as printed paper. They do not answer all the questionaries at once, but at seven different visits at the doctor, the last being...

I also posted another question about the setup of a search-button on the form. This post explains a bit more about the database I am going to create: access-programmers.co.uk/forums/showthread.php?t=240701

I find it very strange that there is no complete tutorial on the subject, and when I search, I find lots of different approaches! Do you recommend somthing like this? functionx.com/access2003/applications/survey.htm

My first database is going to be made for a clinical trial. The patients fill out lots of different questionaries, and there will be lots of blood samples, and measurements of different kinds. Every patient are being followed for half a year, and the different information needs to be recorded...

And keep more than one table? I just ran into the problem of me wanting more than 255 fields (90 x 3) exceeding the limit for one table.

Every row represents a specific person. Every person are going to answer different questionnaires at different times. The specific problem is that one questionnaire with 90 questions is to be answered three times, and in different weeks, hence the prefix-identifiable fieldnames. When I have...

My database has three tables with many columns. The three tables are identical in the names of their columns. I want to copy all columns from all three tables together into one single table, giving the respective columns prefix table1-, table2-, table3- since the columns would otherwise be...