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

The problem may be being caused if you are trying to compare dates that where assigned by the Now() function, this function will as assign a time component (hh:mm:ss) as well as the current date this will mean that now two date assigned by that function will never match if you try to compare them using an "=" function.

If you use DateValue([YourField]) this will return only the date value of the field.

Unless you specifically need a time component on your date stamp use Date() (returns the current date only) in preference to Now().

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

Normalization is often the answer when there are issues with Table structures. Since you have provided no details in that area, it will not be possible to verify your concerns at this time. Providing the following will help us to help you more.
A copy of your database with enough sample data to allow us to see what your concerns are.

OR

Copies of the Queries that create the problems

OR

Written Description of the Table structures involved similar to the following:
TableName
FirstColumnName -- FirstColumnType
.
.
.
LastColumnName -- LastColumnType