Macer,

It is also better to use join, just from a technical perspective. I can't remember where I ran into this situation. But in setting up a join in VB, I believe is where I ran into this, the recordset is not updateable if where is used. You must use join to create an updateable recordset.

PF

>Hi,
>
>Has anyone tested to see if using the join clause is quicker than using an equivalent expression in the where clause. If so, is it significantly faster.
>
>Thanks
>
>Mace.