Search results

Thanks Thanks pdx man, that works just fine! Now all I have to do is convert the big query....:rolleyes:

Thanks pdx man, I'll give it a try and let you know how I get on. FYI statement 1 does work in Access, it returns true/false based upon the validity of the test ie "is Completed True? if so return 0", but I see where you're going with the Select Case Regards Richard

Hi, the following is a small part of a much larger query in Access. I'm trying to convert the query to an SQL view, but the syntax has me stumped!:confused: There are 2 problems. 1) [Completed]=False AS OJ (should return 0 if false or 1 if true) 2) IIf([BRef]='B001',0,1) AS BR (should return 0...

Ahh the infamous null issue :mad: Your code should read as follows Private Sub ResetTxtBoxes() If isnull(cmbBox1) Then Me!cmbBox2.Enabled = False Else Me!cmbBox2.Enabled = True End If End Sub The use of the "IsNull" method is the only sure way to catch nulls. Also note...

A Blank result could be a number of different things. The first thing to understand is that you are trying to do a DMax on a text field and this can return unpredictable results, like the following... Field Contents null - 1 2 3 4 5 10 DMax will return 5 as the highest :eek: ! However...

Select text within single quotes Try lastwaste = DMax("[wastebatch]", "[Job Sheet]", "[wastebatch]<>'-' And [sheetid] = " & SheetID) When a condition is based upon text, the text should be enclosed within single quotes Regards LinData