Hi
I have tableA and tableB. I need to get the records in tableA which does not have a match in tableB. The match is found in AutoNumber in tableA and a Text type field in tableB.
How can I cast Text into Long Integer and then write the query?
many thx
I have tableA and tableB. I need to get the records in tableA which does not have a match in tableB. The match is found in AutoNumber in tableA and a Text type field in tableB.
How can I cast Text into Long Integer and then write the query?
many thx