Search results

  1. S

    Using Concatenated fields as Query Criteria

    Sorry...I didn't realize that it was in bad form to post a question to two different forums. I apologize. I have relied on these forums for answers many times but had never posted before. I wasn't sure how quickly responses came back and definitely needed answers quickly but I do apologize. I...
  2. S

    Using Concatenated fields as Query Criteria

    Uncle Gizmo, Thank you for your help. I would be curious to see it work the way you suggested but as a heads-up, I was able to get it working via VBA as follows if you would be interested in seeing this other approach offered to me on another board: Private Sub Command22_Click() Dim strCrit As...
  3. S

    Using Concatenated fields as Query Criteria

    What does Chr(34) mean and do?
  4. S

    Using Concatenated fields as Query Criteria

    Thank you Uncle Gizmo! To be clear, I just copy and paste that into the Query criteria for the field in question (Capital Need)? Kurt
  5. S

    Using Concatenated fields as Query Criteria

    I am trying to combine the results of a combo box and a text box from a form and use the result as criteria in a query that feeds a report. The combo box is a list of operators (=, >, <, etc) and the text box is a user entered amount (i.e., 5000). The combination would be "> 5000" and should...
Back
Top Bottom