Search results

I have a table that has dtOpenDateTime and dtClosedDateTime fields. These fields contain dates and times the record was opened and closed in a format such as, 2/27/2010 11:34:15 AM. What I am trying to do is get a WHERE clause in a query that will pull records that have the same open and closed...

Hi, hope one of you experts can help me out. I have query that does calculations using data from two tables. The two tables do not have any fields in common so I created a translation table to join them. When I run the query I seem to be get getting the results you would explect from a Cartesian...