The report I am writing requires me to allow users to fill two parameters based on a field in a table (dynamic parameter list of the field) and the parameters are used to control data selected (current period date and previous period date).  Doing this results improper data being returned. I am not getting records that do not have a match in either one of the periods. So I decided to use the Sql command and write my own code. This is working quite well. However, I hard-coded the dates during my initial testing. How do I go about getting the parameters the user selects from the dynamic list incorporated into my SQL Command?

 

Thanks in advance for the advice.