--- Begin Message ---
Hello,
I am trying to create a report where the data is being filtered with the
following code:
PRINT hpreport WHERE discharge IS NULL +
AND company <> '003' +
AND nexthp < .vtoday +
OR nexthp BETWEEN .vtoday AND (.vtoday + 7) +
ORDER BY room ASC, nexthp ASC +
However the order by does not work. I get an order by room number, but
then not by the nexthp which is a date field. I thought that I should
put a 'group by' in since I need to basically group by building a floor,
and then show the dates in ascending order on each building/floor.
Every time I try to put a group by clause in here it gives mt the
illegal column specification error. What am I doing wrong here? I'm
sure I am overlooking something really simple. :-)
Thank you,
Jennifer Roberts
Business Applications Specialist
Ohio Masonic Home
--- End Message ---
This electronic message contains information from The Ohio Masonic Home, its
operating subsidiaries or affiliates. The information may be confidential,
privileged or otherwise protected from disclosure. The information is intended
to be received solely by [email protected], for use as designated in the
message. If you are not the designated recipient, you are instructed not to
review, disclose, copy, distribute or otherwise use of this transmission or its
contents. If you have received this transmission in error, please notify The
Ohio Masonic Home immediately at [EMAIL PROTECTED]; in addition, please delete
your record of transmission. Sending, receiving, downloading, displaying,
printing material that is harassing, fraudulent, offensive, intimidating,
defamatory, or otherwise unlawful or inappropriate is strictly prohibited by
The Ohio Masonic Home.
