Query does not run ? 1

[ItIsHardToProgram]

When processing the following query access freezes and then closes.

SELECT tblTimeSheet.IdProjet, sum(tblTimeSheet.Lundi+tblTimeSheet.Mardi+tblTimeSheet.
Mercredi+tblTimeSheet.Jeudi+tblTimeSheet.Vendredi+
tblTimeSheet.Samedi+tblTimeSheet.Dimanche+tblTimeSheet.
LundiRD+tblTimeSheet.MardiRD+tblTimeSheet.MercrediRD+
tblTimeSheet.JeudiRD+tblTimeSheet.VendrediRD+tblTimeSheet.
SamediRD+tblTimeSheet.DimancheRD) AS TotalTemps;

There are currently less then 2000 entries in each column.

The data is numbers only (supposedly, thats what Im trying to find out). The column is set on numbers only, doubles with decimals, max of 2 decimals.

Why can't access process it, it should be really fast?

I can process innerjoin with group by with the same selection

Any idea why this does not work ?

"Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence."

 

[PHV]

Your query lacks the FROM and GROUP BY clauses.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ItIsHardToProgram]

I realize it is necessery, I don't know where my head was, thank you.

"Knowing that you know is the greatest sign of stupidity, knowing that you are ignorant is the best proof of intelligence.