[RBASE-L] - Re: RBase 6.5++ Query structure

Sun, 30 Jul 2006 10:28:45 -0700 

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.
================================================

Reply via email to