Recent content by moody3829

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...

I figured it out. Not sure if it's the right way, but I ended up doing a subqueries to get my results. strSQLRetrieve = "SELECT Sum(intNoansredir) AS intRONAs, Round(Sum(intNoansredir)/Sum(intAcdcalls),4) AS intRONAsPercent, tblDailyACD.txtLogID, " & _...

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...