Data in TableA not in TableB

[kingz2000]

Hi Every1,

In MS Access, is there a way of creating an SQL to show data in a table which isn't in another?

For example,

Table A has one column called "Digits".
Table B has the same column.

In Table A the Datasets in "Digits" reads {1,3,6,7,8}
In Table B the datasets in "Digits" reads {2,3,7,}

I would like an SQL where all the digits in A not listed in B would be shown.
Hence my result should be {1,6,8}

I thought it would be

select Digits from TableA where digits are not in (select digits from TableB )

but MS Access gives me a weird message saying TabelB.mdb is not on my desktop..

Can anyone help??

Thanks in advance.

 

[PDreyer]

You should post in an MS Access forum