Search results

Thanks very much, Colin, for your offer to help. After banging my head on it all day, I created a copy to send you and then opened it yet again and checked all the properties of the form. I had missed passing a field name. This is why I will never be a programmer - not enough attention to...

I have attached two snips - one is the info on the field and the other is some test data I entered. I tried to search on pears - got all records Sigh

Thanks for your answer but it does not work Yes, it is tablename.field not databasename.field - sorry for the confusion but No, putting OR instead of AND did not work. My problem is the third part of the query. If I search on Name, that works. If I search on State, that works. However the...

I have created a query by form using the instructions here: __________ 1. Create unbound form with text boxes for each field to search. Name text boxes. Save form and reopen it 2. With form open, create query In order to get variations on the search term use asterisks and Like Like "*" &...

Thanks so much! It looks good to me. I'll have dinner, rest a tad, and then see if I can make it behave. I greatly appreciate all the time and trouble you've put in to helping me!

Hope so - looks like it. You'll see there's two similar tables - AthletesDisciplines and Results. Results didn't work so I tried AthletesDisciplines...

Thanks! I tried - still stuck. I'm sure it's something glaringly obvious that I just keep missing. I feel that I'm very close... And it doesnt' look like the forum uploader wants to upload my db. Sigh.

Thanks much. I just addressed you, George, to say I agreed with your particular point but I'll gladly accept assistance from all who offer. I've done quite well splitting out all objects to their own tables - it's getting them to talk to each other that stumped me. What you're saying about...

Hi, George I totally agree. Where I'm stuckest is that I need a many-to-many relationship for athletes and events. Should I be using lookups to populate the tables? Where do I create the form where I enter the athlete's result in an event (I don't know which events the athlete competes in...

Hi, Trevor Thanks. I have created the main tables. I'm stuck figuring out how to link them and which types of links to use - it's the relationships I can't figure out. I know all the basics of creating tables and queries and forms, etc. before, but I haven't created relationships between...

Hi - I have bitten off a little more than I can chew; can't quite sort out how best to organize my data for a sports result tracking DB. We have many employees Each employee has a 'team' of 5 athletes There are a number of sports. Each sport has a number of disciplines. Each athlete competes...