johncollier1
Registered User.
- Local time
- Today, 03:21
- Joined
- Mar 17, 2013
- Messages
- 17
Hello everyone
Here’s a good one
The operative at my place of work produce a product that they have to measure every 25m for QC reasons, and then, the information they generate, I want to store in a database. I have no problem creating the database except for one thing. I need to calculate a median of the QC data and store that in a median field
So, is it possible to calculate the median of value from multiple fields in a table even if some of the fields are NULL? And if so how the heck is it done
The QC table looks like this
QC-ID (AutoNumber)
25m (Number)
50m (Number)
75m (Number)
Etc. all the way up to 400m
QCMedian (Number)
Here’s a good one
The operative at my place of work produce a product that they have to measure every 25m for QC reasons, and then, the information they generate, I want to store in a database. I have no problem creating the database except for one thing. I need to calculate a median of the QC data and store that in a median field
So, is it possible to calculate the median of value from multiple fields in a table even if some of the fields are NULL? And if so how the heck is it done
The QC table looks like this
QC-ID (AutoNumber)
25m (Number)
50m (Number)
75m (Number)
Etc. all the way up to 400m
QCMedian (Number)