Recent content by bull57

I hate it when I do something stupid like that. Worked fine. Kept auto-correcting to that in Design View, changed it in SQL view. :banghead: Thanks.

I have a similar problem but sadly that is not the fix for me. I already had my query programmed in that way but I am still experiencing a problem. As this is just testing, I am going to post my code below: SELECT Len([MAIN].[ADDRESS]) AS LEN, MAIN.ADDRESS FROM MAIN WHERE...