Query of Multiple Items in One Search

[nanscombe]

Ah, I think I know what you mean.

My table will only store distinct values, so if your text file had multiples it will only store it once. You would see fewer records in the table than the number of entries in the file.

It should still pick up all records with the debtor numbers contained in the list.

 

[AmySmith]

Yes, it lists it once in the table, but it does not pick up all records, it only pulls one...

 

[nanscombe]

Really? That's surprising.

The next thing I would check is, for records with a particular debtor number, are the values truly identical. Numbers of zeros, spaces etc

I'd make a query based on SCA_T, pick a value from tmpDebtor, then copy and paste it as a parameter to see if actually pulls back what I'm expecting.

Another thing to look for would be any records things like o instead of 0.

If you need another pair of eyes you could always just extract the debtor number by itself into a table, which wouldn't cause any confidentiality problems I would have thought, to post. Then give an example of the values giving problems.

Possibly not 250k worth of records though.

 

[AmySmith]

I can make it work like this. Thanks so much for ALL of your help!!!