Search results

  1. D

    delete certain variables from string

    Has anyone an idea how to delete certain numbers/letters from a string? So lets say I have a string "05605080" And I want all the "0" out of it in a way that this string is left: "5658" All help is appriciated. Rob
  2. D

    Between dates or is null

    I have the following criteria in my query: Between [Forms]![frmMenu]![Sub]![van] And [Forms]![frmMenu]![Sub]![tot] This works fine, but when the boxes [van] and [tot] contain no data, the query shows no results. I want the query to show all records if these boxes are empty. Does anyone has...
Top Bottom