Have a problem with the Data

[DevilDog1978]

I am creating a database to view various calibrated assets. I am taking data
from two sources. The first is a program that lists the standards and is
distributed monthly. The data in this program is accurate. The second program
is a data extract from a database used to track the inventory of calibrated
assets. One of the problems I am facing is that some of the standards come
with options. In the first program the options are listed in the format of
(part#)OPT(option#). Most of the records entered into the database are
formated as (part#)0PT(option#). Is there a way to get Access to compare and
match items that match a record by a certain percentage? I am dealing with
almost 7000 items and the information grows monthly. Manual entry is not an
option. Any help that can be provided would be greatly appreciated. Let me
know if more clarification is needed.

 

[Jeff Boyce]

Are you saying, for example, that AssetID = 17 has a 'calibration' standard
(e.g., 17.3), plus/minus some variability (e.g., .9)?

Or are you saying that AssetID = 17 has 'variants', for example, 17a, 17b,
17c, ...?

If you linked to (or imported) the raw data {(part#)OPT(option#)}, you could
use a query to 'extract' the option info.

But what does your data structure look like? "How" depends on "what"!

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP