Search results

THAT'S what I had the blank on. Needed to add the Field name into the false part. Thank you so much CJ. Told you I needed a hit with a stick. Couldn't see the birds for the trees.

This is the combo source SELECT DISTINCT sqryResultJudges_MultiJudge.SectionID, ucase(sqryResultJudges_MultiJudge.Section) FROM sqryResultJudges_MultiJudge " & _ "WHERE ((sqryResultJudges_MultiJudge.JudgeID = " & Me!cboJudgeSlips.Column(0) & ") AND (sqryResultJudges_MultiJudge.RingID = " &...

WHERE YourField = nz([forms]![frmMain]![cboWorkSlips],YourField) won't work because there are no records that have a zero or null. They will have only 1,2,3 or 4.

I should say that I can make the "ALL" option anything a null or 0. So Null,1,2,3,4 or 0,1,2,3,4

This is the SQL. I didn't include it as it is a bit long winded. Basically it selects which records to print on a report. SELECT DISTINCT tblShowDogs.ExhNo, tblShowRingJudges.JudgeID, tblDogDetails.Group, tblShowRings.RingNO, tblShowDogs.Adult, tblBreedType.Breed, tblTitleType.Title...

Hi all, having a mental block on this one. It should be easy but I can't get it. I have a query take returns results based on several combos. Standard stuff =[forms]![frmMain]![cboWorkSlips] etc. However on two of combo critieria selections I would like to have and "ALL" option. Once again...

Hi all. Been using access since '97 and before that DB3/4. Just like DBs and getting out data that is meaningfull and useful etc. Written a few apps of the years and have a couple that I sell. Joined because it's always useful to other ideas and to help out when I can.