I wouldn't know how to attach an entire DB. Anyway the situation is like I described in the first message. I just changed the fields name. Now the starting query is this one:
Behind is like that:
Where "ID_imbarchi_anagrafica" is linked to the ID main form.
"N" is the progressive number of onboard experiences.
"Dal" is from (date)
"Al" is to (date)
"TOT" is the field calculating the number of days spent on board.
I tried to insert the "DSum" code in the sixth colum to have the progressive sum, but it says there is a mistake in the syntax.
This is the code adapted to the new field names:
Code:
TOTALE: DSum("[TOT]","[imbarchi_stageqry]","[ID_imbarchi_anagrafica] =" & [ID_imbarchi_anagrafica]" & " AND [N] <= " & [N])
This is the screen message:
It says: "Syntax error in the expression - Operating or operator missing, letter or comma invalid or input text not included in quotation marks".