SQL statement for query

vickriz · September 24th, 2003, 12:36 AM

HOw to make a query that finds in a field in surname which abbriviated only.
sample records:
NAME SNAME
Luieso A
Abelardo Cano
Cherry D
Chayong K
Abdula H
Paul Akir

the result of the query would be:
NAME SNAME
Luieso A
Cherry D
Chayong K
Abdula H
=====================

pls help..

Mabuhay!!!

misterqj · September 24th, 2003, 05:48 AM

Doing a little testing in Access 2000/Win XP the following SQL works for me.

Code:

SELECT names.Name, names.Surname
FROM [names]
WHERE ((Len([names.Surname])="1"));

vickriz · September 24th, 2003, 10:10 PM

Quote:

quote:Originally posted by misterqj
Doing a little testing in Access 2000/Win XP the following SQL works for me.

Code:

SELECT names.Name, names.Surname
FROM [names]
WHERE ((Len([names.Surname])="1"));

im getting an error when i run this..
SELECT myTable.Surname, myTable.FirstName, myTable.MiddleName
FROM myTable
WHERE ((Len([myTable.MiddleName])="1"));

error encountered:
"Invalid backeting of name '[myTable.Surname]'."

by the way in using access 98 in win2K.

Mabuhay!!!

vickriz · September 24th, 2003, 10:12 PM

im getting an error when i run this..
SELECT myTable.LastName, myTable.FirstName, myTable.MiddleName
FROM myTable
WHERE ((Len([myTable.MiddleName])="1"));

error encountered:
"Invalid backeting of name '[myTable.MiddleName]'."

by the way in using access 98 in win2K.

Mabuhay!!!

vickriz · September 24th, 2003, 10:16 PM

Quote:

quote:Originally posted by misterqj
Doing a little testing in Access 2000/Win XP the following SQL works for me.

Code:

SELECT names.Name, names.Surname
FROM [names]
WHERE ((Len([names.Surname])="1"));

Hi again... thanks for help i got it correct now...

just forget to used a close bracket; (Len([myTable].[MiddleName])="1"))

more power misterqj..

Mabuhay!!!