Solved Concatenating variable in SQL Statement

[jeran042]

I keep getting a run time error: Run time error 2465- "Microsoft access cant find the field" and I'm sure that I am not concatenating correctly.
Any guidance or suggestions would be helpful.

 Set rsQuery = dbs.OpenRecordset("SELECT * FROM qryLedger_Detail_2019_Exhibit WHERE [EXHIBIT_2_COST] = " & sCost_Center Or [COST_CENTER] = " & sCost_Center & ")

 

[theDBguy]

Hi. Just a guess, but maybe try:

 Set rsQuery = dbs.OpenRecordset("SELECT * FROM qryLedger_Detail_2019_Exhibit WHERE [EXHIBIT_2_COST] = " & sCost_Center & " Or [COST_CENTER] = " & sCost_Center)

 

[jeran042]

Hi. Just a guess, but maybe try:

Set rsQuery = dbs.OpenRecordset("SELECT * FROM qryLedger_Detail_2019_Exhibit WHERE [EXHIBIT_2_COST] = " & sCost_Center & " Or [COST_CENTER] = " & sCost_Center)

This was perfect, thank you for the quick response.

 

[theDBguy]

This was perfect, thank you for the quick response.

Hi. You're welcome! Good luck with your project.