Using labview to fill in a Between [start] And [End] criteria in an access query

[FMM]

I am trying to use the database connectivity toolkit and the execute query vi to fill in criteria in an access query:

Between [Start] And [End]

I have successfully used the execute query vi to fill in one variable, for example Enter Part Number [Number] by combining the query name in a string with the input variable in quotations.  I can't figure out how to enter two variables though.  I've attached a picture of the query I'd like to run using Labview.

Any help is appreciated.

Thanks.

[Zwired1]

Use "format into string" or string concatenation operations to insert the criteria into the SQL query text.   In ACCESS, you can click on something -- I forget exactly what -- that will show you the SQL that corresponds to the query you have captured from design view. Take that ACCESS-generated string and replace your criteria with '%s' as I did in the attached example.

[FMM]

Thanks for the reply.  Any chance you'd be willing to upload a picture of your code, I'm still on LabView 8.2.

Thanks again.

[Zwired1]

saved for 8.2 below.  Also a block diagram screenshot in case it doesn't open for some reason.