Can you have an INNER JOIN with the sql statment for this method?
Printable View
Can you have an INNER JOIN with the sql statment for this method?
Yes, as long as your query is valid.
Moved
it wont let me do an inner join...and these queries are valid
Create a query in Access and set the ReportSource as the query object.
But I have, for instance, date values that are part of the search string coming from my VB DtPicker...how do I pass those along to a pre-created query...
I did as you said, worked like a charm. I passed my WHERE querie in the WHERE parameter for OpenReport
Sorry for the delay, was out on a call. Glad to see its working now. ;)