Search results

  1. D

    Variable Field name for Select query or split columns

    Hey all! I have a dilema: I'm essentially building a tooltip for an object based on data found in a table. I have the following function to query for the data: Public Function getItemTip(ByRef col As String, ByVal item As String) Dim query As String query = "SELECT ITEMS." & col & "...
  2. D

    Normlized Tables. Cannot get Queries and Forms to work correctly

    I have 3 tables: PERSON ---------------------------------------- PK PERSON_ID AutoNumber FIRST_NAME Text LAST_NAME Text NUMBER_SET ---------------------------------------- PK NUMBER_SET_ID AutoNumber FK PERSON_ID Number...
  3. D

    Get value from a Table1 col1 where Table1 col2 equals Query Value

    Confusing question? The only way I can explain it best is to show it: Table1 --------------------------- Name Num1 Num2 Num3 Devin 224 18 845 Scott 322 32 652 Jim 179 46 929 Tim 202 41 562 Query Getting Max Value --------------------------- Num1...
Back
Top Bottom