Well I never did figure out what was going on, so I deleted everything out, compact/repair, re-imported, compact/repair, and everything seems to be ok now. Must have been some corruption or something =/
--- In MS_Access_Professionals@yahoogroups.com, "Graham Mandeno" <graham@...> wrote:
>
> 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