Hey there,
In my database I am trying to create a query made up of fields from other previously created queries. In these previous queries there are chemical sampling dates and values. Most of the dates match up but some do not, and this causes access to duplicate values where dates do not match.
Is normalization the answer here? And if so is there a method i can use that does not involve scrolling through thousands of data points to find where dates do not align?
Thank you for your help