Dsum with AND (.......OR......)

[apestaarten]

I try to use Dsum to sum the ours ill for a particulair location whereby the recover date or the moth still ill are valid for a month.
Here under my code :

Ziekteuren = DSum("[Aantal uren ziek]", "Verzuim Query1", "[StationID] =" & StationID & " AND (Datepart('m',[Datum herstelmelding]) =" & DatePart("m", Maand) & " OR Datepart('m',[MaandNZ]) =" & DatePart("m", Maand))[\code]

I receive an error 3075.

Can someone help me?

Best recards,
Apestaarten

 

[SkipVought]

Is this MS Access? In which case you ought to post in one of the many MS Access Forums.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

Why not posting the whole error message instead of only the number ?

Anyway, I'd use this:
Ziekteuren = DSum("[Aantal uren ziek]", "Verzuim Query1", "[StationID]=" & StationID & " AND (Datepart('m',[Datum herstelmelding])=" & DatePart("m", Maand) & " OR Datepart('m',[MaandNZ])=" & DatePart("m", Maand)[!] & ")"[/!])

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

 

[apestaarten]

Hallo PHV,
Once more you heave given me the right solution!
Thanks!
Small question, where can I find the rigth syntax or is there a way to see what is missing?
Best regards Apestaarten.