Discuss "query error" in the Microsoft Access forum.

todd2006 · #1 July 29th, 2008, 08:46 PM

Hi,

I have this query

Code:

strgets = "Select distinct Sports1 AS sporting FROM Points WHERE LEN(Sports1) > 0 and CombinePoints.Id=" & getid

I want to see that length of sports1 field is empty

I dont know if access allows to check the length of a field

todd

Rebelle · #2 July 29th, 2008, 09:29 PM

wouldn't that be IsNotNull?

Rebelle · #3 July 29th, 2008, 09:45 PM

try:

Code:

SELECT points.sports1 as sporting
FROM points
WHERE ((Len([sports1])>0)) and combinepoints.id=" & getid

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Microsoft Access - Microsoft Access is a database for small to medium applications. Learn tips and tricks and best database practices here.