Results 1 to 3 of 3

Thread: SQL with VB report

  1. #1
    Join Date
    Feb 2003
    Location
    england
    Posts
    2

    Question SQL with VB report

    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!!)

  2. #2
    Join Date
    Feb 2003
    Posts
    2

    A little more info please...

    Could you post a complete SQL statement (including the hardcoded dates) that does work? That would help in debugging a bit.

    Stu

  3. #3
    Join Date
    Feb 2003
    Location
    england
    Posts
    2

    Question

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •