Search results

Hi guys, I hope this is a really easy one to solve, and that I'm just missing something trivial that'll make everything snap into place... Here's the cast - Tables - people bth_modules bth_results (joined to people (by person) and to bth_modules (by module)) Query -...

Excellent, that's just what I needed. Thanks a lot! I see your point. I used tick boxes because it was easier for me to visualise it (this is my first big database project), and the list of tickboxes is unlikely to change frequently. Now that I am (a little bit) older and wiser, I would...

Just to revisit this one, if I may... The above solution works fine, so obviously now I've been trying to do something a little more clever with it. :rolleyes: I have successfully linked the tables underlying the queries, so that they can look up some course code information in another table...

Poor old Access. I think I've made it wave a white flag, but based on the following expression I am trying to get it to evaluate, I'm not too surprised... The situation is that I have a large number of tick boxes on a form, which nicely filter through to a series of fields in a table whose...

Fantastic! That's exactly what I've spent the last 6 hours trying to achieve. :rolleyes: You are my personal hero for the day. Thank you very much!

Access is making my brain hurt - can anybody please help? Here's what I have and what I am trying to get it to do... I have a table, maba_registrations, into which students are entered according to which course they are doing in which semester - eg - autonumber student_id course_code...