Look Up Function

[chad101]

I’m designing a database for a metallurgical lab. Everything works fine except I have nothing in place to check for typos in my inspection results field. With 15,000 records added in the past 2 months it’s very cumbersome fixing errors when a PPK report needs to be printed. My approach is to write a function that checks the inspection result with that of the spec-high/low table. I don’t think Dlookup() is what I am looking for. My PK is based off part number and inspection type. When I user enters a result the function would need to query the Spec Table and check if “result” is higher or lower than required spec high and low. If so, the database would prompt the user with a msgbox asking if value should be accepted or not.

Customer – Number
partID – Number – PK
inspection – Number – PK
specHigh – Number
specLow - Number

 

[JoeCruse]

Chad,

are these inspection results in a regular format (I mean, is there a set list of words for the result of a test)? If so, an update query could fix the table of results.

 

[chad101]

I have a list of inspection types but the result for each inspection is a user defined numerical answer. That’s where the problem is. Say a user intends on inputting 38.9 and makes a typo and 389 is entered.

I’m looking for a way to check the inspection result and see if the result is less than or greater than the allowed min and max inspection result for a given part number. tblSpec tracks the specifications for a given part number.