Unanswered: SQL Paramter Query -- Just like in Access
I am trying to create a dynamic query to build a recordset, but it needs to prompt the user for a value. Since I obviously can't know what fields are going to be requested or any sort of desired value range, I was hoping that a "parameter prompt" was available, sort of like in Access when one uses brackets. I'm using VB6 with an Access 2003 back end (though we hope to soon move it to an SQL server).
Many thanks and if you need more info, I'll be happy to give it.