>I didn't realize VFP was more on SQL based (i've never used it actually). If you are using the inner join in Access it should be working. There's no reason off the top of my head why it shouldn't. Can you .zip your access database and e-mail it to me so I can see exactly what is happening. It will probably be easier then messaging back and forth. My e-mail address is jdalio@northernhealth.ca. As long as it is zipped you should be able to send it.

I've sent the zipped file (in forwarded message) to you. Thanks again.