Fejl i SQL query

SQL = "SELECT COUNT(log_ip) AS uniqueIp, COUNT(logp_url) AS pages "
SQL = SQL & "FROM log, logPages "
SQL = SQL & "WHERE logp_ini = log_index AND (log_datetime BETWEEN #9/30/2002 00:00:01# AND #10/1/2002 23:59:59#) "
SQL = SQL & "GROUP BY log_ip"

Fungere ikke!

SQL = "SELECT COUNT(log_ip) AS uniqueIp, COUNT(logp_url) AS pages "
SQL = SQL & "FROM log, logPages "
SQL = SQL & "WHERE logp_ini = " & log_index & " AND (log_datetime BETWEEN #9/30/2002 00:00:01# AND #10/1/2002 23:59:59#) "
SQL = SQL & "GROUP BY log_ip"

mon ik' det er sådan?

//>Rune

har prøvet den, men den dutter heller ikke....

hvis jeg skriver

QL = SQL "SELECT COUNT(log_ip) AS uniqueIp, COUNT(logp_url) AS pages "
SQL = SQL "FROM log, logPages "
SQL = SQL "WHERE logp_ini = log_index AND log_datetime BETWEEN 9/30/2002 AND 10/1/2002 "
SQL = SQL "GROUP BY log_ip"

Så får jeg ingen fejler, men et tomt recordset, og jeg ved der er poster der svare dertil.
Men det er tomt fordi der ikke er tidspunkter på, men bruger derimod tidspunkter, så får jeg et utal af fejler......?

Sådanner manner.......!

SQL = "SELECT SUM(logPages.logp_count) AS pages "
SQL = SQL &"FROM log INNER JOIN logPages ON log.log_index = logPages.logp_ini "
SQL = SQL &"WHERE (log.log_datetime BETWEEN '9/25/2002 00:00:01' AND '16/10/2002 11:59:59') "
SQL = SQL &"GROUP BY logPages.logp_ini "

Så svarene hjalp slet ikke?