I have three tables CUSTOMER, MATERIALS and ORDER. The first two contain info about customers and materials(these are chemicals). On the MATERIALS table there are a list of tolerances e.g. top temperature and bottom temperature. In the ORDER table I can choose the customer and the material then I list the actual temperature etc. I want to create a query which will produce a Pass or Fail for each tolerance based on comparing the actuals to the top and bottom amounts. I could do this function in Excel using IF but am having problems in Access. I would also liek to produce a certificate at the end (a report based on the query) which would have Pass on it if all of the individual tolerances have passed.
Any help greatly appreciated. Thanks in advance.
Note: Not used VBA before so expressions and where to put them would be appreciated.
Launcher
Any help greatly appreciated. Thanks in advance.
Note: Not used VBA before so expressions and where to put them would be appreciated.
Launcher