YES YES YES!!!

You are absolutely right!!!! I forgot that fields in SQL that are keywords need brackets around them when referencing them in VFP. Arrrg.

THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU THANK YOU!

Everyone else's suggestions were good too! I plan on using them when I run into other problems.

Thanks everyone!