Search results

Thank you for all your help with this. The ID field is something that it suggested everytime I made a query or table and I'd click "ok" but I wasn't reas sure why it should be there. As I said, this is my first use of Access for anything at all. Now I get to try and figure out how to upload...

Ok, I repaired the relationship thing, but it still isn't pulling any results. I"m afraid I've jacked something up somewhere with the result that it isn't doing what it should. I've set up the query just like the example you provided as best I can. Any ideas?

I can't get the relationship between the two tables to be the same as in your example. The only 'common field' it shows is the ID Column.

Sure, In the database I supplied, All pilots should list as "None" since it has 0 as the minimum requirement for all 3 criteria. Also, Doc has met the requirements to be a member of the order of the British Empire and yet has not been awarded that. After looking at it in each case it is where...

I"m using Access 2003 and I can't open the file you posted with the extension .accdb

Sure, I found an error I had made, it now pulls some results, but its not pulling them correctly and I"m not sure why. Perhaps I should tell you this is my first foray into the world of Access. Thank you very much for your help with this.

Ok, I've looked at your solution and tried it with what I currently have and its not working. My guess would be because the Totals earned for each pilot currently exist only in a Query and not in a table as you have set up in your example. How do I get the results of the Query I have that...

Ok, problem 2 I have with my current project. Ok, first allow me to tell you what I'm doing. I am setting up a database to track Pilot Statistics and Awards for a group of gamers that play IL-2, a WW2 combat flight sim game. I have established 2 tables: Mission Results (where the results of...

As I stated in the original post, I already have a Query that does the following: [/INDENT]What I'm looking for is a way to compare the information generated by this Query to the requirements in the table British Military Orders and see which pilots have earned what awards. Or did I miss...

I've spent the last 4 hours searching Google for an answer and can't seem to locate any advice that works for me so here goes: Ok, first allow me to tell you what I'm doing. I am setting up a database to track Pilot Statistics and Awards for a group of gamers that play IL-2, a WW2 combat...