Query help - please

  • Thread starter Thread starter Scott Duncan
  • Start date Start date
S

Scott Duncan

We are trying to adapt to a legacy system...

We perform Calibration Service. Each [individual] Calibration Test, we enter
the Serial Number of the Test Weight used. This is in a comma delimited
format.

Typically there are multiple Tests in the series.
CSA Test Number Test Weights
15451 2857 90, 91
15451 2858 90, 91, 92, 93, 95, 96, 97, 99, 100
15451 2859 502, 503, 504, 505
15451 2860 90, 91, 92, 93, 95, 96, 97, 99, 100
15451 2861 90, 91, 92, 93, 95, 96, 97, 99, 100
15451 2862 90, 91, 92, 93, 95, 96, 97, 99, 100
15451 2863 20, 90
15451 2864 90, 91
15451 2865 502, 503, 504, 505


We need to figure out a Query that uniquely identifies each Test Weight
used. New regulations are requiring us to provide calibration data on each
Test Weight.

Unfortunately, we just went thru an ISO Audit and the manner that we are
currently entering in the Test Weight Serial Numbers is 'cast in stone'
until our next Audit.

TIA,

SD
 
The Split Function can parse the comma delimited list to an array. This
requires some VBA code to perform, and cannot be used in a query.
 
Yes,

This is an Access 2003 application.

I have not used the Split() function before. I will give it a shot.

Thank you,

SD

[MVP] S.Clark said:
I'd better qualify that my Split() answer is for A2k and newer.

Scott Duncan said:
We are trying to adapt to a legacy system...

We perform Calibration Service. Each [individual] Calibration Test, we enter
the Serial Number of the Test Weight used. This is in a comma delimited
format.

Typically there are multiple Tests in the series.
CSA Test Number Test Weights
15451 2857 90, 91
15451 2858 90, 91, 92, 93, 95, 96, 97, 99, 100
15451 2859 502, 503, 504, 505
15451 2860 90, 91, 92, 93, 95, 96, 97, 99, 100
15451 2861 90, 91, 92, 93, 95, 96, 97, 99, 100
15451 2862 90, 91, 92, 93, 95, 96, 97, 99, 100
15451 2863 20, 90
15451 2864 90, 91
15451 2865 502, 503, 504, 505


We need to figure out a Query that uniquely identifies each Test Weight
used. New regulations are requiring us to provide calibration data on
each
Test Weight.

Unfortunately, we just went thru an ISO Audit and the manner that we are
currently entering in the Test Weight Serial Numbers is 'cast in stone'
until our next Audit.

TIA,

SD
Click to expand...
Click to expand...
 
Back
Top