I have 3 nearly identical queries running that, in turn, are ran by 3 nearly identical reports.
Everything is the same in regards to what fields/data to pull for my report. The only difference in the reports is which query they call.
The queries SELECT, FROM, and JOIN statements are exactly the same. The only difference is in the WHERE statement. The difference is that they each query the data differently, though the criteria uses the same table field. In one query I'm asking for info NOT equal to a specific term, the 2nd asks for info EQUAL to the term, and the 3rd ignores it (returns all info)
Here's the string, the section my question refers to is in bold.
WHERE (((SRComment.Date) Between [Forms]![FISReports]![From Date] And [Forms]![FISReports]![To Date]) AND ((SR.SRType)="Project")]);
My question is, what is the syntax to have that bolded part refer to a combo box on a form? That way I will need only 1 query and only 1 report as the selection will be made in the combo box.
I know this is convuluted. I hope some of you can make sense and help me out.
Thanks!
Everything is the same in regards to what fields/data to pull for my report. The only difference in the reports is which query they call.
The queries SELECT, FROM, and JOIN statements are exactly the same. The only difference is in the WHERE statement. The difference is that they each query the data differently, though the criteria uses the same table field. In one query I'm asking for info NOT equal to a specific term, the 2nd asks for info EQUAL to the term, and the 3rd ignores it (returns all info)
Here's the string, the section my question refers to is in bold.
WHERE (((SRComment.Date) Between [Forms]![FISReports]![From Date] And [Forms]![FISReports]![To Date]) AND ((SR.SRType)="Project")]);
My question is, what is the syntax to have that bolded part refer to a combo box on a form? That way I will need only 1 query and only 1 report as the selection will be made in the combo box.
I know this is convuluted. I hope some of you can make sense and help me out.
Thanks!