Search results for query: *

Thanks for replying. The subselect query is getting the max routid for the each reference of MasterID in the routing table; that's what the Group By is for. I want a single RoutID for each MasterID. The MasterID is the FK in the routing table; it's the PK in the MASTER table. I tried the...

Does anyone know a better way to do the following query? SELECT [CCM_DETAIL_1_ACT].[FNAME], [CCM_DETAIL_1_ACT].[LNAME], [CCM_DETAIL_1_ACT].[ORG], [CCM_MASTER_1_ACT].[INPUT], [CCM_MASTER_1_ACT].[DUE], [CCM_MASTER_1_ACT].[FILENO], [CCM_MASTER_1_ACT].[DOCKET]...

Woops... should have read the last sentence more carefully. I'll look at it and let you know if I come up with anything.

You can turn off the warnings by using the following: DoCmd.SetWarnings False If you want to turn them back on after all queries have been run type: DoCmd.SetWarnings True Phil

Thanks for your reply. I got it to work, but without using the vResults=Call basSelectCriteria.selectCriteria(ctl). This would not work for me. I simply declared a global variable. Thanks.

I have the following bit of code placed in a module: Function selectCriteria(ctl) 'Flush out the Criteria variable before adding new data Criteria = "" 'Loop through the list box and build a string 'for all items selected For Each Itm In...

This may help: http://www.mvps.org/access/api/api0065.htm Hope it does. Phil

OK, here is my situation. I have a table with a list of courses a student can take. In the same table is another field that lists the prerequisite course, if there is any. Now, there is a form that I've created that allows the user to add eligible students to a class (the class is related to...