Results 1 to 2 of 2
  1. #1
    Join Date
    May 2012

    Unanswered: Filling in data from existing data


    I have a query which returns results in the following format :-

    Name Area Sales
    James M Good
    James S Null
    Mark M Poor
    Mark M Poor

    Sales is a calculated field. Is there a way, in the query, to have the Null changed to "Good", based on the fact that James has a rating of "Good" in another row?

    (Each "person" will only ever has one type of rating per query. So, James will never have an instance of "Good" and "Poor" elsewhere.)

    Many thanks

  2. #2
    Join Date
    Apr 2012
    How is the Sales field calculated? Maybe it's possible to include in that formula that if it is Null, then return "Good" (or Poor).

Posting Permissions

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