Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Filtering with Math (2000)

    Below is an equation that I wrote for a query criteria and got a data type mismatch. I am trying to filter records with this criteria that if the SHIP_CHARGE is between 0.073* NET_VALUE and 0.077*NET_VALUE . SHIP_CHARE and NET_VALUE are both fields in the query.


    "SHIP_CHARGE" Between 0.073*"NET_VALUE" And 0.077*"NET_VALUE"

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filtering with Math (2000)

    Try replacing the double quotes around the field names with square brackets...
    NET_VALUE with quotes around it makes it a string... Therefore Access can't multiply that string value by .077...

    Try: [SHIP_CHARGE] Between 0.073*[NET_VALUE] And 0.077*[NET_VALUE]

    HTH

Posting Permissions

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