Sniper-BoOyA-
Registered User.
- Local time
- Today, 10:02
- Joined
- Jun 15, 2010
- Messages
- 204
Good Morning / Afternoon,
Ive got the following query:
But its not responding to anything i do. And when i remove table tblopv (in design view) it works great.
Any ideas?
Ive got the following query:
Code:
SELECT labgegevens.monsternr, tblstabilisatiecilinders.*, (([massaschlmonnat]-[massa3])/([massa3]-[massaschl]))*100 AS watergeh, (([massa]/(100+[watergeh]))*100000)/[opvinh] AS drgdchthd, tblstabilisatiecilinders.opvnr, tblopv.opvgew, tblopv.opvinh, ([totaaldruk]/[opvgew])*1000 AS d7, ([totaaldruk]/[opvgew])*1000 AS d28, Round([d7],1) AS rondd7, Round([d28],1) AS rondd28, labgegevens.proefnummerstab, labgegevens.proefnummerstab
FROM tblopv RIGHT JOIN (tblstabilisatiecilinders RIGHT JOIN (labgegevens LEFT JOIN tblwatergehalte ON labgegevens.monsternr = tblwatergehalte.monsternr) ON tblstabilisatiecilinders.monsternr = tblwatergehalte.monsternr) ON tblopv.opvnr = tblstabilisatiecilinders.opvnr;
But its not responding to anything i do. And when i remove table tblopv (in design view) it works great.
Any ideas?