Results 1 to 2 of 2

Thread: Filter problem

  1. #1
    Join Date
    Sep 2011
    Posts
    36

    Unanswered: Filter problem

    Im trying to filter a report between two dates using an expression in the control source, but for some reason it makes a mess of the formatting of the date.

    This is the expression im using

    =[Date1] Between [Forms]![Select Report Dates]![frD] And [Forms]![Select Report Dates]![toD]

    If i just put just Date1 in the control source it displays the date fine, just obviously with any filter.

    Any ideas?

  2. #2
    Join Date
    Sep 2011
    Posts
    36
    Got this sorted now

Posting Permissions

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