Search results

Dear access users, I was able to create search as you type form from info from your excellent site. I use it to search through a music database. So i have a table with Artist and Title in it. So when i type queen i show the results in a subform as i type. But ia have multiple "Queen" records...

Haven't had much time tested in your example and it does exactly what i want. Tonight i will test it in my envorinment i'll post back as soon as possible

Thx snueberg, I have looked at your DB and my problem is that i have more dates in table availablehours than in workedhours. Users are available but they don't work every available date. So when i add the date of today 9-6-2016 it doesn't show up in the combine query. When i change the second...

Dear, I have created a tables users with userID and have 2 tables with 1-to-many relations to userID: tblAvailableHours (Fields userid - date - availablehours) tblWorkedHours (fields userid-date-workinghours) In both tables a have a date field. I would like to create a query to get as a result...