MS Access database - ('" & CUSIPS & "') in Where condition

Question

Just I want to check what is exactly ('" & CUSIPS & "') in where condition or criteria...

Could you please help on this. Thank you

Regards, Jagannath

Quite difficult with no info at all ... – Gustav Feb 07 '19 at 13:53 — Gustav, Feb 07 '19 at 13:53

score 0 · Answer 1 · answered Feb 07 '19 at 15:20

If this is in your Query Editor, you can add [CUSIPS] as a new field to your query. The value will be displayed in this new field.

If you're calling this from VBA, you can use Debug.Print just before your query code:

Debug.Print CUSIPS

See this related question on using Debug.Print Where does VBA Debug.Print log to?

1 Answers1