Search results

vbaInet, I had to read your solution at least 10 times until it finally made sense, and even then it didn't. So I went ahead and followed your instructions and, voila, it worked. Thank you so much, I managed to brighten up my day.

Hi Simon, I have one (hopefully) last question. So here's data in the two tables described above, slightly more complex: tableA: City_______FullName____DaysAvailable Toronto--__Alex--------20 Chicago--__Bob---------20 tableB: FullName___DaysUsed Alex-------1...

Thanks Simon, your solution would work. I have yet to try it out since the real program is quite a bit more complex but I trust you know what you're doing. I dont really understand why I shouldn't store these values but now that I think about it, I guess there's really no need since the query...

Hello everybody, I have a quick question, a piece of cake to most of you, I'm sure. Here's the simplified scenario: I have two tables: tableA, with two fields: fullName, daysRemaining tableB, two fields as well: fullName, daysUsed daysRemaining starts out with 15 and decreases with every entry...