Search results

Thanks! I've done it without the left join, for now, if they haven't answered the question not much point listing it. I think I was trying to count the wrong field, now I'm counting RID instead it all appears to work. Cheers! :D Gary - Not entirely sure I understand but these aren't all Y/N...

I have a query where one of the fields contains a function to stip spaces and cut the first 4 characters. This works fine in a query, but the report based on this query asks me to enter a value into that field. I'm guessing this is something simple ? Any Ideas ? Thanks

If you want a popup box before submitting then Javascript is the way - because of the client/server interaction this must take place on the client side. Alternatively you can submit the data, either with AJAX, or just as you would normally with ASP then check the values and display an error on...

Hmm, I've given that a try and its still going horribly wrong - I ended up with600 results and there are only 8 respondents in the db at the moment. Reading over what I wrote I'm not sure if i explained it properly. I want to have the postcode from tblRespondents, the question for question 1...

I shall try that out, thanks! I think I was pulling all data in both queries then attempting to join, rather than just pulling the answers then adding the respondent info, which makes a lot of sense now you've suggested it. Cheers :D

I have a database spread accross a number of tables, I'll simplify it a bit here - there's questions, answers, respondents each as seperate tables. Respondents includes RID Name PostCode Questions QID Question Answers AID QID RID Answer The answer table contains answers to all the different...

Firstly hello, I'm new! :) Sorry for creating yet another thread on table design/relationships for surveys, I did search just needed a bit of clarification. From what I understand from my search the best way to create a basic db for surveys would be a question table, response options table...