Sniper-BoOyA-
Registered User.
- Local time
- Today, 08:42
- Joined
- Jun 15, 2010
- Messages
- 204
Good Morning,
I could need some help with the following Query :
This query is the source of a form, but when i open the form, i can not add / edit any data. Do you know why?
I could need some help with the following Query :
Code:
SELECT queryverdgrdzand1.tbllabgegevens.monsternr, queryverdgrdzand1.tblverdgrdzand.monsternr, queryverdgrdzand1.schaalnr, queryverdgrdzand1.massaschl, queryverdgrdzand1.massaschlmonnat, queryverdgrdzand1.td1, queryverdgrdzand1.massa1, queryverdgrdzand1.td2, queryverdgrdzand1.massa2, queryverdgrdzand1.td3, queryverdgrdzand1.watergeh, queryverdgrdzand1.massa3, queryverdgrdzand1.osczand, queryverdgrdzand1.opmverdzand, queryverdgrdzand1.tblverdgrdzand.laborant, queryverdgrdzand1.optimumwatergh, IIf(IsNull([osczand]),"",DLookUp("[inhosczand]","[tblosczand]","[oscnr]=" & tblverdgrdzand!osczand)) AS inhsczand, ((tblwatergehalte!massa3-tblwatergehalte!massaschl)/[inhsczand])*1000 AS drgdichtheidzand, ([drgdichtheidzand]/[drgdchthd])*100 AS verdgrdinsitu, querymaxtotaal.watergehproct AS optimumwatergeh, querymaxtotaal.MaxVandrgdichtheidproct AS drgdchthd
FROM queryverdgrdzand1 LEFT JOIN (querymaxtotaal RIGHT JOIN tblproctor ON querymaxtotaal.proctorID = tblproctor.proctorID) ON queryverdgrdzand1.tbllabgegevens.monsternr = tblproctor.monsternr;
This query is the source of a form, but when i open the form, i can not add / edit any data. Do you know why?