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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jaccess

  1. jaccess

    Hi, I have an SQL statement that

    hi in response to your Dlookup syntax..try this set a variable, in this example, quote to equal a " (quote). then concatenate the quote variable as in the example below this has worked fine for me using DoCmd.RunSQL Let quote = Chr$(34) "DLookUp(" + quote +...

Part and Inventory Search

Back
Top