Scenario-help (posted in Macros too)

[tarek_habal]

Hope I am posting my question in the correct place. First of all I am entry level user in access, but knowledgeable in excel. As I am working with data containing over 65,000 rows I decided to use access however I don’t know how create a function that will work give the same result as (vlookup) in excel. Scenario case: first column “Serial Number” contain a list of serial numbers, 2nd column will be fed manually or by a bar-scan, the third column should show the value of “1” if the value in the 2nd column exists in the first column else a value of “0” should appear

The validation formula in excel looks like: =IF(ISERROR(VLOOKUP(B2,$A$2:$A$65000,1,FALSE))=TRU E,0,1)

Serial Number Confirmed Serial Validation
141614661
141614662
141614663
141614664
141614665
141614666

Thanks in advance,
Tarek
tarek_habal@yahoo.com

 

[The_Doc_Man]

Do this using the following concept:

On your list of serial numbers, be sure that the serial number (if it is unique) is set up to be Indexed, Unique.

When you scan your bar-code, use the IN clause or (alternatively) DCOUNT to decide if the serial number is in your table.

Look up Access Help for "IN" and "DCOUNT" - they are two different ways to skin a cat. MMMMMEEEEEOOOOOWWWWWRRRRRR