Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    California
    Posts
    502

    Unanswered: Filter on Control Source of curreny filed of detail record in a report?

    Contorl source for currency field SP

    [SP] >=100000 AND <=299999

    Fails!!!

    The report is NOT based on a query but the table itself. I trie filtering the [SP] field in the table. Failed.

    Thanks

    Rick

  2. #2
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    Do you mean you have set the ControlSource for a field on your report to
    [SP] >= 100000 AND <=299999
    ????
    That does not work in a ControlSource for any field, currency or not.

    Are you trying to filter the data for the report? If so, you will neet to do that with a query, or in the filter parameter in the .OpenReport command.

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Your syntax appears wrong anyhow. Try this
    Code:
    [SP] >=100000 AND [SP] <=299999
    George
    Home | Blog

Posting Permissions

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