coding which has been used thus far is ... SELECT .... From..... WHERE tbl..DateofGame = tblSer.Search. The last two parts of the SQL were created in a similar to an Access query - ie in Access you can create a parameter search within a query to print out the required info and then use this query to create a report. We are trying to do the same thing with VB but only using the data environment to create the report instead of the coding VB to print the report.