I have a pupil who would like to create a report using the report using the Data Environment in VB. However he would like his clients to be able to search for data by using a date which will need to be input via the user interface on opening the report. The report will need to be created using SQL but although we have tried several options I have been unable to create the query without using specific dates within the coding. Possible coding could be SELECT ..... FROM .... HAVING .... (This is where I need the SQL to read the date from the users input!!)