select ptmeds.station, ptmeds.txdate, ptmeds.patype, ptmeds.genmedname, ptmeds.strength, ptmeds.unitsm, ptmeds.volume, ptmeds.dosage ptmeds (((ptmeds.station)="emer1") , ((ptmeds.patype)="withdrawn")) <i need @ genmedname field here also> group ptmeds.genmedname;
i need able sum based on ptmeds.genmedname , sort results highest lowest. i've looked thru other responses similar question cannot find need do. appreciated.
select ptmeds.station, ptmeds.txdate, ptmeds.patype, ptmeds.genmedname, ptmeds.strength, ptmeds.unitsm, ptmeds.volume, ptmeds.dosage ptmeds (((ptmeds.station)="emer1") , ((ptmeds.patype)="withdrawn")) group ptmeds.genmedname order ptmeds.genmedname desc;
Comments
Post a Comment