scenario-help

[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))=TRUE,0,1)

Serial Number Confirmed Serial Validation
141614661
141614662
141614663
141614664
141614665
141614666

Thanks in advance,
Tarek
tarek_habal@yahoo.com

 

[statsman]

If I understand you correctly:

The Serial Number will be in the first field.
A manual entry or bar code reading of the serial number will be in the second field.
The third field is to confirm that the Serial Number has been confirmed.

I'm sure you have a good reason for this, but it seems redundant to me.

Why not enter the bar code in the first field? If there's a number there then it's confirmed. If it's blank, it hasn't been entered yet.