Link to home
Start Free TrialLog in
Avatar of sebastiano72
sebastiano72

asked on

The Search Key was not found in any record

In Access 2007 I run query on a linked DB table (about 120mb in size) and a message box tells me "The search Key was not found in any record". The search I apply is on the year 2011, I know it is there in the table.
What could be wrong?
Avatar of jerseysam
jerseysam
Flag of United Kingdom of Great Britain and Northern Ireland image

Remove any prefixed space characters. Sounds like 1st character was entered as a space by mistake, so it cant find the value
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sebastiano72
sebastiano72

ASKER

SELECT MOVMAG.ANNREG, *
FROM MOVMAG
WHERE (((MOVMAG.ANNREG)="2011"));
Database1.docx
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial