Thanks, But I am actually trying to print the report showing only those people who have done less than 100 hours is both years not just one. If I run your query I get those with less than 100 hours in either year or both. All I need is both years.
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ben Petersen Sent: Sunday, July 30, 2006 1:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: RBase 6.5++ Query structure Duncan, You can change your original by replacing the and with "or". The cannot be 2003 AND 2004 at the same time <g>. (year =2003 and totalhours <100) OR (year=2004and totalhours <100) I don't use the object manager, but the statement would be better written as: Where totalhours < 100 and year in (2003, 2004) Ben Duncan Walker wrote: I have a table holds the following information - the volunteers name - The hours volunteered for the year by each volunteer. (This info is held for multiple years ie 2001, 2002, 2003 etc). I am using the Object Manager- Reports and the Where Builder and am trying to create a query that will display all volunteers who have done less than 50 hours, each year, over a number of years ie 2003 and 2004. I am having a problem as I'm not very good at these compound queries. I had tried the following but got back no rows. (year =2003 and totalhours <100) and (year=2004and totalhours <100). I would appreciate any help. Thanks Duncan --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
