Hi,
I have written a small lookup program in Access to extract data from a commercial program also in access.
The lookup is to determine the consignee (customer)of second hand school uniforms.
The way it works is that S/H items are tracked by using serial numbers, which are the customer Id number plus a – and a number, to allow for several items of the same type, as consignee. The program works well, but due to human cussedness the consignee’s name is often entered or the number is wrong format.
I’m trying to create an exception report to give a listing of all serial numbers that don’t correspond to ANY customer Id.
Have tried criteria of “<>Customer ID”, however, that gives me 100s of thousands of results, because every customer Id is not the same as all the other customer Ids.
Unfortunarely the customer Id is of varying length 3 to 5 characters and also of the format 12/9876. Valid serial Nos should look like this:-
123-7
54321-5
12/9876-2
Wrong entries look like this:-
123 – 9
54321 -3 (which actually works because the space
left when the last 2 digits are
stripped is ignored in the lookup)
Joe Bloggs -1
As I’m not a programming guru a fairly straight forward idea would be appreciated.
TIA.