Thank you, but the information pulls alright, I will change the code for ease of use though. The problem is that I want the information to grouped by building and floor, and then ordered by date ascending. However all I can get is the report to group by building and floor and then start new page breaks then, but it completely ignores the date being sorted. I do not see anything in the break to do any type or sort or order by…. ???
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ben Petersen Sent: Monday, April 28, 2008 1:59 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Illegal Column Specification > WHERE discharge IS NULL + > AND company <> '003' + > AND (nexthp < .vtoday + > OR nexthp BETWEEN .vtoday AND (.vtoday + 7)) Just for ease of maintenance, and maybe a little performance, maybe > AND (nexthp < .vtoday + > OR nexthp BETWEEN .vtoday AND (.vtoday + 7)) could be > AND nexthp < (.vtoday + 8) [between is inclusive of 7, right??] so your where clause could be > WHERE discharge IS NULL + > AND company <> '003' + > AND nexthp < (.vtoday + 8) Ben 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.
