Imar - thanks for your patience!
In plain english - I am trying to list locations that are not used for the current freezer, box and tower. So, if I selected a freezer, tower, box that was empty it would return all 100 locations (001-100) and if I selected a freezer, tower, box that had data in it - it would only retunr locations were there wasn't any data.
I have a table that has just the locations 001-100 listed in it.
The table I store the all the sample data in only contain locations that are used.
Hope that helps! Once again thanks for all the help,
Chris
|