Recent content by Mackem Nat

Hi Wayne I have taken some of your advice and an trying a not to elegant solution. I was worried that basing the count of the query would still give a #error regradless of where the parameter can from. I have therefore gone down the route of: Using a form to ask a start and finish date Using...

Dear SD & Wayne I have been search through the forum to find the answer to my problems amd you both seem to be the closest that have solved the problem. I have a table with a range of fields (around 50). I have then set a query which just copies most of the data, but if a few cases does a...

Prince among men (or princess and women) Cheers I have had a play and been able to get both methods working with a limited number of fields. Still a few bugs to iron out on the full blown version but definately on the right track. Thanks for your help

Thanks for your patience so far, I think I understand but it isn't crystal yet. At the moment I have one form which lets say is asking: Name Age Gender Date the form was completed Address (Country & Town) And Sports they like to play. Some answers like gender are obvious male/female (yes/no)...

Cheers the welcome and for the quick reply but................. I have already added a few queries with parameters so I have an idea how this works but this seems more complicated for 2 reasons. 1/ The criteria can chenge for each of the fields (and I have over 30). Some are just yes/no...

Hi to anyone and everyone I am pretty new to Access and am quickly losing patience with my "dummies" book. I have a set up a database for someone else and they don't like using the filter form function in the database and have asked for form that does the same job and mentioned "query builder"...