Search results

Ka-ching, the bill just went up. This what you're after?

ps there is the usual 10% consultancy fee - I like the look of some of them numbers!

Your welcome

Well, there's one off the list

Haven't given much thought to my own reply to this, but the best description I ever saw was for Bulgarian soccer player Hristo Stoichkov: "The genius of a Da Vinci and the temprament of weeping gelignite" Who intrigues you?

I don't think sub tables is the right expression, but along those lines: If product is the primary table, then 1 product record can have many contacts, 1 contact record could have many adresses etc etc

You need to go right back to basics and firstly understand 1 to many relationships and redesign your tables much more efficiently (search on normalisation). The key will be deciding what is the primary table: Contacts? Products? Other?

It might help to attach database so we can see it

Thanks kindly, works a treat - muchos gracias

I have tried several solutions propsed in searches of the forum, but can't get any of them to work. I have a form with a text box and combo box, with subform derived from a query. If I enter value in textbox and select from combo box, all is right with the world, I am after all records if I...

??? I know not these names

Well, list your best ever South African team

something like this (qryMainSum) ??

Try "like [Vendor's Name:]*"

Depends on the purpose of the database, is it for Business or Personal use? If business, then personal details should be kept to a minimum

Do you have any actual data to work with?

You ask many questions - I have used LL and Sl as foreign keys to primary key in tblLakes (this is the primary table) How I sighted species should make no difference - caught, viewed makes no difference - if sighted field <1 then will show up in count If I did not observe species, does that...

I send you pm to continue this if you wish

This could go on for a long while - you can contact me at deagar@nexnet.net.au so we can solve the problems and then post the finished result in the forum I am happy to work with you on this, but I also have several other projects on the go, so it may take some time David

Glad to help