How to pass a Parm to the Query
I have a sales sheet. The Devart Qry brings in a table SMB_Budget. I want to filter that table on a salesman (smb_salesman). Is this possible, and if so, what is the approach I should use? The salesman number will be in a Cell in the excel spreadsheet for the user to select and refresh. It would need to be passed to the query.