Apologies- Very generic question

Hi there.......I realise nobody can answer this without seeing the project but if anybody has a thought of where I can look that would be awesome. I have a large dB in Access 97 and i generate multiple reports from it. I have a criteria form where the user chooses a field from a cbox as criteria. The report generates perfectly for all choices except one! I am pulling my hair out trying to find out why. The data types and properties seem to match:

ex.
This one works

fieldOne: EK Descreption: EAST KOOTENEY

This one does not:

fieldOne: M Descreption: MARATIME

Do the Descriptions have to be spelled properly? :D If so, try MARITIME

haha....spelling was never my strong point. However that wasn't the problem. I just traced it back. The query references a table that has incomplete data at the moment. I should have known!!! Sorry to waste everyones time.