Search results

Ok I'm one of those who cannot program at all. Never said I wasn't, on the contrary, I keep saying I'm trying to learn something here. But opening an excel worksheet filling it with dates and then copying it to an access table isn't quite an automated way of doing things. And what happens if...

Thanks but, in order to test it, I need a tblCalendar filled up with calendar dates. How on earth am I gonna do that. 🤣

Well thank you both @arnelgp and @ebs17 for answering but your suggestions don't seem to do the job. Maybe I should be more clear : When user registers a "booking", first thing he does is passing down the dates (RentalStart, RentalEnd), then the Customer (CustomerID) and then the seat...

Hi everyone, Here I am again with a really tough brain teaser. We have some events going on, in which Customers (tblCustomers), rent Seats (tblSeats) to attend the event, paying a daily Rate (tblRates) who’s Min and Max values are being predefined by the user, according to Seat Category...

Ah boy! This is too much! I'm gonna integrate it in my db and see how it goes. I had designed a form for Rankings and Stats but I think I like yours better! Thank you so much! P.S. Not so long ago this forum had a rep point system (or am I wrong?) IF EXISTS you got all I can give! Thank you...

Now it becomes too complicated for my poor knowledge. That update would be wonderful, whenever and if you're comfortable :). Thanks again.

Yeah, that's the easy way but I'm trying to learn something. :)

Well, I hate to do this but, I really had to come back. First of all, the solution you came up with, works like a charm and I honestly find it very smart. I could never think of it. And, thank you, thank you again. It’s not only the solution that you gave but the lesson I got in thinking the...

That's what I was trying to do last night, all night, failing again and again :ROFLMAO: Thank you!

When all stats are equal (like in the case of TeamID3 and TeamID5), they count total goals differential again along with the one of the matches among them. In that case TeamID3 is 5th, TeamID5 is 6th, and TeamID7 is 7th (as you made it). I really believe this thread should be pinned for the...

Ah boy. This is wonderful! Let me implement it and compare results to the official ones. One question for the time being : Where do I trigger the UpdateTempTable Sub? On Loading the Ranking form maybe? (Never mind, answered when I saw the attached file). I really can't express my admiration...

this actually isn't right with all criteria taken under consideration. TeamID 3 is 5th. TeamID 7 is 6th, TeamID 5 is 7th TeamID 9 is 9th, TeamID 14 is 10th, TeamID 10 is 11th right now

Ranking is basically based on total points won. In case of a tie (two or more teams) the following are taken in consideration (in respective order): Total points won in matches among the tie teams Goal balance (differential) only in matches among the tie teams Goal balance (differential) in all...

Not an expert, but this usually happens when there's a multi-value lookup field somewhere in the tables involved. Is that the case?

That's all information needed. Note that in case of ties in qryTeamStats I must calculate points AND goals ONLY for the matches among the teams involved (if any). Thank you

Thank you for answering. Actual data isn't in English so it wouldn't be easily read and understood. I'll modify it a bit and will post basic information needed for the task. Thanks again

Well actual Teams table is: (names have been changed) actual matches table is : and actual rankings table (a query) before applying all criteria needed, is : You see there are 3 teams with 8 points and 3 others with 4. Their ranking though isn't right because above mentioned criteria...

Well, It doesn't apply at draws as a match result, which shouldn't be a problem since it's a draw after all, but it takes under consideration all teams' matches (not only the ones' with the tie.) Thus, in the example above, TeamD gets a higher ranking than TeamC and TeamB, although there has...

Wow!!! Looks you gave THE solution. Have to try it more though, to find out what happens if match's result is a draw, but it looks it'll be no problem. Thank you so much, can't find words to express my gratitude for even bothering!!!

Thank you arnelgp. I'll try it and come back.