Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Select Statement


Message #1 by Martin Lee <access@o...> on Mon, 15 Apr 2002 16:03:06 +0800
Am trying to set up a form which would allow users to view records from a 
specific month and year. There are two combo boxes on the form: cboMonth 
(January to December) and cboYear(2000 to current year).

Any pointers on the Where part of the SQL statement to only retrieve 
records from selected month and year?

strMonth = Request.Form("cboMonth")
strYear = Request.Form("cboYear")

SQL = "Select * From tblDeposit Where DepositDate =" 'Am stuck here:)

Thanks,

Martin


  Return to Index