Very weird!
Try this query:
SELECT * FROM tblEmployee WHERE Left(EmployeeID, 3) = '009'
- Graham
> From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Lee
> Sent: Saturday, 22 October 2011 13:30
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Strange result of query
>
>
> The data was imported. I ran the ascii query and every row was 48 =/
>
> --- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno"
<graham@...> wrote:
> >
> > Hi Lee
> >
> > How was the data entered? Was it imported from somewhere? It is possible
> > there is something invisible at the start of each field.
> >
> > Try this query:
> > SELECT EmployeeID, Asc(EmployeeID) as FirstChar FROM tblEmployee WHERE
> > EmployeeID LIKE '*009*'
> >
> > In the FirstChar column you should see only 48, but I suspect there will
be
> > another value - what is it?
> >
> > Best wishes,
> > Graham
Tidak ada komentar:
Posting Komentar