Search results

Many thanks both, yes it was the spelling after all - must have been query blindness!!

Hi Folks, tearing what little hair I have out with this.. I have a form (community_courses) with a combo box upon it (course_desc) that I am trying to reference in a query based upon the value in the combo box when the form is open but then I have read that one cannot reference a combo box...

Hi Plog, there aren't any relationships - just the one table (community) so I am unable to show any at the moment. Not to worry, I'll keep trying different versions -of the same statement- even an ape learns eventually :-) thanks for all you help.

Hi Plog, I renamed the field to remove the space and did as you suggested but I am still getting a syntax error when I try to run the query. Thanks

Hi Jdraw, thanks for replying, yes I do understand about the naming conventions - I'm going to tidy all that up at some point once I've cracked this query bit :-) There are only two tables - Community & Targets which have no relationship at the moment. I have visited the two links already thanks...

Hi, I think my problem relates to a sub query I am trying to create. I have created a simple course tracking database that creates a record for each course and includes the following fields (staff member responsible, course name, venue, start date, end date, course capacity) and a few more. The...

Hi, I'm an Access newbie and hope to pick up some tips while I create a new course database. Maybe I'll eventually get to contribute once I'm up to speed... CJW