Error in query ??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a running sum query, which I included below. It works, but when I try
to create a chart based on the query, Access gives me an error message and
reloads. I guess it's because there is a mistake in the query ?

Can you see anything that could cause the problem ?

SELECT (SELECT sum(prof) FROM profit_par_session AS temp WHERE temp.date <
profit_par_session.date) AS Recno, profit_par_session.date
FROM profit_par_session;
 
Back
Top