Search results

  1. L

    using an if statement on an sql string

    I'm populating an access report from an sql string thus: (edited version below) SQL = "SELECT asset.Local_ID, asset.Category, asset.Asset_Label, asset.Asset_Loc, " _ & "asset.Task_Price, asset.Invoice_Price" Me.RecordSource = SQL No problems, everything is working fine...
  2. L

    convert a month to a number

    Hi I've got a combo box that displays the months of the year. I want to return a number from the selected month eg January returns 1, February returns 2 and so on.. Cheers Luigi
  3. L

    Using a combo box to filter dates in a query

    Hi I have a field in a query that must select all sale dates within a particular month. This month is passed from a combo box (cmbMonth) on a form (frmSalesByMonth). I want to put the code on the criteria line. I've got this far Is Not Null And [Forms]![frmSalesByMonth]![cmbMonth]????? Any...
  4. L

    SQL date range dilemma

    I'm importing a date from a form and putting it into SQL as a string variable but its not finding any records. Here's the important stuff Dim SQL, str1, str2, strDate As String str1 = Forms![TestForm].[Start_Date] str2 = Forms![TestForm].[End_Date] strDate = "Between #" & str1 & "# And #"...
Back
Top Bottom