Search results

That is a great summary of what I'm doing. Thanks Dave. BTW I have a copy of "DAO Object Model" by Helen Feddema, I noticed a photo of your copy in a thread from last year. I'm coming back to Access after a long (8 year) absence and have started reading it again. That is why I'm very rusty...

I'll have to get back to you for an accurate answer. I've got to log out now. I'll get back to you. I'm sure you are right.

It was: Exclude Duplicate Records from a Query Sorry for the bold, I copied and pasted. Keep going and I'll hit the 100! :>)

Here it is, there are no hyperlinks or other links in it.

I'm happy to not include links either internal or external. If I need to I'll wait to my 100 posts limit is reached (only 16 to go). That's all.

I'm innocent. I haven't included any links. I certainly won't be doing so in future. Solved.

I can't make a post to my "How to find an Administrator" thread. Because of the link that @The_Doc_Man asked me to post. @The_Doc_Man

This is the only way I could make a new post. I couldn't post my reply to my other thread because I got the administrator message again.

I'm online now. What is the test?

No I wasn't.

No link in my post.

Thanks for the message! I'm still getting these spam messages and I'm unable to complete posts to the thread I am on. By the way, what is a PM? Is it Personal Message? It seems that I can post to this thread without the administrator message preventing me.

I did reply and quoted the post I was answering. I'm still trying to post to that thread but I keep getting the administrator message

I'm trying to make a post but I keep getting messages that my post is spam-like and I need to contact an administrator. I don't know where to look. I've attached a copy of my post, which seems OK to me, but I can't make a reply. How do I find an administrator?

Thanks for the replies with lots of great ideas. I certainly have enough to solve my dilemna now. Thanks all This will also help with another query I'm yet to do. This will have many more duplicates and possibly triplicates. These horses have Trait Y. So I could make some smaller tables using...

Thanks Gemma, So in the races with more than 1 candidate with Trait X I don't want to consider either of them. They are disqualified from further consideration. That is why I want to exclude them from further analysis. I only want 1 candidate per race, not 2. The person who created the data...

I've realised why there may be some confusion.. I'll need to explain further. These queries concern analysing Horse-Racing information. The query I ran concerned getting a set of results where some horses have a characteristic called X. There is usually only one horse per race has that trait...

Thanks, Can I make a query into a totals query? That sounds like a good idea. I just want to exclude the dupes so I can analyse the non-dupe records. I'll try that out and get back to you. Thank you. I just did that but it didn't exclude the dupes. The SQL is attached.

I looked at the table in the first instance and saw a couple of dupes. I then ran the Find Dupes Wizard that gave a list of 12 records that are dupes. Rather than delete them, I thought I could run a join that would not include the dupes. But that requires SQL which I'm very rusty at. I...

How do you do that?