Search results

Ok seems good but ... Do I need a special field in my members table? Presently I have a members table with usual stuff - cant make up my mind whether I need a Lapsed (Yes/No) field in it. I also have a payments table with payment ID and memberID which links obviously to members, via memberID...

I posted a plea for help regarding using the date from 1st Setember of one year thru to 1st September of next Year. No answer was the stern reply, so I'm trying to rephrase the question. Does anyone know how to deal with memberships for a club where the date starts in one year but continues to...

Can see a problem I can see the problem however my database is based mainly locally because it is a rugby club for our immediate vicinity and most members live local to the club so fingers crossed I wont need too many other area codes that will confuse the issue- I wouldn't have a clue how to...

UK Zip Code Many thanks sounds good. I guessed it was something like that butkept getting the 'space bit' wrong- will try it.

I guess this is pretty fundamental but I cant get it right! I want to search for a member by post code so I need to have validation for my table field post code so that when my parameter query accepts the post code input records will be returned covering all input types e.g. Users can put in...

I've inherited a database for members who join in September for 1 year e.g 2004 but need to be renewed following september 2005. I want to calulate who has paid up within 3 months from september by dec 1st which allows them to purchase tickets for events. I also want to run queries to find who...

I've inherited a database for members who join in September for 1 yeare.g 2004 but need to be renewed following september 2005. I want to calulate who has paid up within 3 months from september by dec 1st which allows them to purchase tickets for events. I also want to run queries to find who is...