Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

QBE problem

Discussion in 'Information Technology' started by Ryan W, Jul 28, 2006.

Tags:
  1. Ryan W

    Ryan W
    Expand Collapse
    Guest

    In my database I have users tracking items on different patients. I am trying
    to write a report that will inform the user of the last action date (using
    Max) and the action. The actions can be alpha or numeric (ex: 24 Hour Call,
    Patient Called, Finished). I want a report to tell me the patients last
    action, but if the patient has "finished" I don't want them to show up on the
    report.

    What happens when I use "Max" under Action I get the numeric value of "24
    hour call" and when I use "Last" I get the last alph item "Patient Called".

    Is there a way that I can use the Max under the date and not use Group by?
    Or does anyone have another idea?

    Thanks for your help, Ryan
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikhs Face Problems While Carrying Kirpans In Khyber-Pakhtunkhwa - SikhSiyasat.Net Breaking News Jul 29, 2016
    "Dasam" Granth - A Look At The Core Problems Dasam Granth Oct 21, 2015
    Problems In Life Sikh Sikhi Sikhism Apr 13, 2015
    How can I make decent and useful friends and from where ?? most people have a problem with me Sikh Youth Oct 23, 2013
    The Problem with Taking Too Many Vitamins Health & Nutrition Oct 18, 2013

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    See:
    Getting a related field from a GroupBy (total) query
    at:
    http://www.mvps.org/access/queries/qry0020.htm
    for 4 ways to solve this.

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Ryan W" <RyanW@discussions.microsoft.com> wrote in message
    news:7CE93528-661B-4FC4-9084-EFF448868D0A@microsoft.com...
    > In my database I have users tracking items on different patients. I am
    > trying
    > to write a report that will inform the user of the last action date (using
    > Max) and the action. The actions can be alpha or numeric (ex: 24 Hour
    > Call,
    > Patient Called, Finished). I want a report to tell me the patients last
    > action, but if the patient has "finished" I don't want them to show up on
    > the
    > report.
    >
    > What happens when I use "Max" under Action I get the numeric value of "24
    > hour call" and when I use "Last" I get the last alph item "Patient
    > Called".
    >
    > Is there a way that I can use the Max under the date and not use Group by?
    > Or does anyone have another idea?
    >
    > Thanks for your help, Ryan
     

Share This Page