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