Dcount Syntax issue with multiple Criteria (Year(date)

[kfschaefer]

Asked by: kfschaefer1


help with syntax: I need to determine if records exists where the quarter value = the value of (i) and the Year = current year (Year(date())

If DCount("Quarter", "tblSummaryQuartersFrozen", "Quarter =" & Chr(34) & i & Chr(34) & "" And [Year] = Year(Date)) > 0 Then


doesn't like the Year(date()),

Just not seeing the issue.

Please help

[June7]

Year is a reserved word. Should avoid reserved words in naming convention.

If DCount("Quarter", "tblSummaryQuartersFrozen", "Quarter =" & i & " And [Year] = Year(Date())") > 0 Then

[kfschaefer]

If DCount("Quarter", "tblSummaryQuartersFrozen", "Quarter = " & chr(34) & i & chr(34) & " And [Year] = Year(Date())") > 0 Then

Did the trick thanks for the input.