Select Query with criteria is shifting column data to the wrong column

  • Thread starter Thread starter BMac
  • Start date Start date
B

BMac

When I do a simple query without criteria the columns
return data correctly. However when I insert criteria on
a certain column, the return data is correct in the first
few columns, but then returns 0's for an entire column,
shifts that column's data to the next column and all of
the following columns.

This works:
Select Center, Amount, CompanyID, AccountID, City, State
From Table1;

All the data shows in the proper columns.

But if I try:
Select Center, Amount, CompanyID, AccountID, City, State
From Table1
Where Left(Center, 5) = '10100';

Center is correct.
Amount is correct.
CompanyID is all 0's.
AccountID returns all 10100, which is not correct either.
City has the correct AccountID's.
State has the correct Cities.

I have tried using the LIKE operator, but I get the same
problem.
I have even tried using a straight = operator to try and
get close to the right data, but the columns don't align
correct either.

For some reason it is shifting my data to the right.
Can someone help me please.
 
Back
Top