Recent content by Ty-Uk

yes it's becoming apparant i should start a new one and do it properly - so that's what i'll do instead of butchering this one, many thanks for your help !!!

table name is Membership Fields are Mem Number (primary key) Name Address Phone 1 park number 1 boat number 1 boat fee 2 park number 2 boat number 2 boat fee 3 park number 3 boat number 3 boat fee there are about another 15 but they are only to do with billing and family info

Unfortunatley it's a database i've inherited and can't really alter it much (as it's the sailing clubs) the reason it has 3 sperate fields is just to make it easier to grab the data for a mail merge, as each field has different pricing. as i'm a relative novice i dont really understand what you...

Hi - i'm sure this is very simple but i can't fugure it out so would appreciate some help. i would like to create a parameter query that searches through 3 seperate fields - ie the 3 fields are boat park 1, boat park 2 and boat park 3.....when prompted i would like to enter a boatpark number...

Brilliant Guys - i used a mixture of advices and i've got it to work - ranjah, the file came in very useful and was the last piece of the jigsaw. Thanks once again - much appreciated Ty

Hi, thanks for the prompt reply - any chance you could be a bit more specific ? i've created a relationship between the two tables linking the two product IDs - but what do i do now ? Thanks again Ty

Hi, i'm a newbie so please be gentle :) ok, i have 2 tables, one is for part number and product ID and the other has product ID and Vehicle details. i know how to set up a parameter query but just can't quite get the result i want, which is to set up a query based on the result of the first...