Using multiple "and" in a query.

Blabolat

Registered User.
Local time
Today, 03:17
Joined
Feb 11, 2011
Messages
31
This is probably really easy and I just can't figure it out.

I have two true/false check boxes on a form, one for Paid and one for pickedup.

On the query builder I have these two fields listed, and I want the records to show on the form if either box is not checked(false). So in the Query builder, I have False for the paid and false for the pickedup fields in the criteria portion.

However upon running the query, if I click on ethier box, the form will update and will not show the record. I have to have both fields True to update.

In other words it's acting like a "or" instead of a And.

SELECT SO.SOID, Players.FName, Players.LName, SO.Completed, SO.Priority, SO.SODate, Players.PLAYERID, Players.Phone, SD.Service, SO.Paid, SO.Picked_Up, Frames.Frame, SD.Amt_Due, SD.Paid, SD.Exteneded_Price
FROM ((Players INNER JOIN SO ON Players.PLAYERID = SO.PlayerID) INNER JOIN SD ON SO.SOID = SD.SOID) INNER JOIN Frames ON SD.FrameID = Frames.FRAMEID
WHERE (((SO.Completed)=True) AND ((SO.Paid)=False) AND ((SO.Picked_Up)=False));

Though I don't do SQL, this is the statement.

Any help I can get I will appreciate it highly..
Thanks!
 
On the query builder I have these two fields listed, and I want the records to show on the form if either box is not checked(false). So in the Query builder, I have False for the paid and false for the pickedup fields in the criteria portion.

I did not fully understand all of your post but this requires an Or not an And.

Brian
 

Users who are viewing this thread

Back
Top Bottom