I am working on creating a Report using SRS but first have to get the correct
information out of my database with a query.
What I am attempting to do is create Honor Roll for one of my schools, and
the requirements for the Honor Roll is a gpa >3.0 and less than 3.99, and

Setting parameter ranges for a query is very useful.
How can I specify : begins with ...... and make that a parameter (in this
case first 5 digits of a project name)?
Liek '%[parameter3]%' does not work.

I'm trying trying to build a crosstab query using a Case statement to count
the number of records in one column with the DateDiff >=0 and the other
column to be a count of the Records with the DateDiff <0. I can do this
easlily in MS Access with the IIF Function in a crosstab ...

I am trying to write a query that returns all suppliers within a given range
that either do not have any insurance (appear only in Suppliers table) or
Suppliers where the insurance has expired from a given date
Eg 4 Suppliers

Thank you in advance for any and all assistance.  I am trying to do a
comparison of 2 tables and I am expecting the result to be what ever is not
in one of the tables.  The table I need the result from has 2 columns of data
that I want returned based on col1 being distinct ...