>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 will do tomorrow from work. Thanks a lot for the willing to help.
If it's not broken, fix it until it is.
My Blog