Recent content by Scanner29Y

I Thank the Lord for you guys! I had the same problem and was driving me nuts!! We tried Union Queries, Left Joins, all flavors of outers (though it got the closest still missing something), until we finally prayed and BOOM!, there was your answer.... Ancient One, keep it up dude! 'cause...

GOT IT!!! :D PAT! Thanks a lot for your help, found the missingpart of this puzzle. All I needed to add to the left Join was OUTER. That's it, so long goodbye, thank you and "Hasta luego"

Should I be looking at a VBA solution or do you guys think it is feasable to do this ?

Pat: Did the fix, but I need to list all disciples on a group no matter what class they have taken. IF they took the class then the date should be reflected. What I got so far is to show the respectives date (for all records on fruits) on the same subform. If I parameter select the query to...

Thank You Pat!! I didn't see your posting unitl after I uploaded the sample, will make your modifications and let you know how it went. Once again thanks for replying.

sample database ok! by popular demand, here is a sample of the database. I need your help on the group section.

Muchas Gracias Ekta :cool:

Could I get that on '97 Flavor Would it be to much trouble to get that file on Access 97? Thanks, got myself unto a little jam like that. I Think it might be useful. l8ter...

Greetings to ya'll from shiney Puerto Rico! (BTW, please excuse my writing, english is not my first language) Need a little help from you Access-Masters out there. We have a database being used to track attendance to different clases. Now, there is a form, let's call it Group, where we...