Search results

Sorry, you are right. I have tried your solution before posting. But english is not my native language, sometimes I find hard to express things here (I´m not used to it). So I chose to give that answer instead. The thing is that the same thing continue to happening. I think SELECT DISTINCT...

Mmm I don´t think that´s going to work =(

I need to build the following query: I have 2 tables: tblBusiness tblInspection tblShops have an ID, an adress, bussines name, owner name, etc every Shop can be inspected many times. A inspection can be futile if the store is closed. If the store is open, the inspection is made, and as result...

I need to build the following query: I have 2 tables: tblBusiness tblInspection tblShops have an ID, an adress, bussines name, owner name, etc every Shop can be inspected many times. A inspection can be futile if the store is closed. If the store is open, the inspection is made, and as result...

I didn´t want to created a "music preference" for the team because it would be to strict, I mean, maybe the person creating the teams would want to choose a team member with a different music preference. Well, I came up to this solution: I put a unbound combobox in the Team with all the...

Right now I´m trying to do this: In the "Team creation Form" I´m adding an unbound control with the Musical Preference, so it can be use to filter the People on a combo-box located in the associated continuos subform (sorry my english sux) But it doesn´t work... I can´t figure out how to refer...

Thank you Simon, you are really kind. I read your solution and I kind of figure it out or understand it parcially, but my brain can´t compute it right now. This part On the Parent Form you could have IDPerson SMT IDTeam TeamC IDPreference Classical Let´s see... you say I...

.............................Please?

It is possible to refer in a SQL statement to the "current" or "actual" record? I want to base the querry in the present value of two related tables. I will try to show you what I have to do, maybe you can give an alternative solution. These are the tables: tblTeam (idTeam, TeamName...