Search results

Hello Thanks for your reply. Yes, I realise I have a flaw in the design and I know it is not normalised. That's why I want to correct it! The structure was done the way it was because initially it was conceived only to help with a statistical analysis of responses, for which this structure...

Hi I am trying to create a mail merge from an access db where the whole structure of the db is wrong for doing this! The db takes inputs from a questionnaire about ten local news stories and whether they are of interest to the reader. The reader is asked to rate their top three stories...

Ah, I see now. It is always so much easier when you understand what the code is actually doing! Thanks very much for all your help. Regards TP

Hi Paul Thanks for your reply. I’m pretty sure that what you suggested is along the right lines, but it isn’t quite doing what I need – but I suspect that’s because I didn’t give you enough information! The query you suggested is doing part of the job, but not all, but I think this is on...

Hi I'm hoping someone can help a frustrated newbie with an Access sql conundrum. I have a memo field in one table which contains a string of comma delimited numbers, which are the autonumber IDs of people who have met a previous search criteria. I want to do a query that finds other fields in...