Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: kieriosity
- Content: Threads
- Order by date
-
Optimizing a Query
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]...- kieriosity
- Thread
- Replies: 4
- Forum: ANSI_SQL
-
Ruturning a Value from a Function in a Module
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...- kieriosity
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Use Query Result as criteria for a second query
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...- kieriosity
- Thread
- Replies: 0
- Forum: Microsoft: Access Modules (VBA Coding)
