Hi,<BR><BR>As hopefully the SQL statement below will show, I am trying to get the id of the latest column entry from each user, however when running the statement I get expected parameter 1, anyone know what&#039;s up?<BR><BR>This is Access btw<BR><BR>SELECT t_columns.user, (SELECT TOP 1 t_columns.id FROM t_columns) AS colid, t_columns.date, t_members.handle, t_members.id FROM t_columns INNER JOIN t_members ON t_members.id = t_columns.user WHERE t_columns.id = colid ORDER BY t_columns.date DESC;<BR><BR>Any help greatly appreciated.<BR><BR>Regards<BR><BR>Smiler