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

    Unanswered: Filling in data from existing data

    Hi,

    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
    Posts
    28
    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
  •