Collect a certain value

[alwazeer]

Please help me in the collection of value in the attached report

[June7]

You want to open report filtered by value entered on form?

This should work but for some reason it keeps erroring.

DoCmd.OpenReport "Test", acViewPreview, , "Year([date])=" & Me.txtyear & " AND Month([Date]) = " & Me.txtmonth

[alwazeer]

You want to open report filtered by value entered on form?

This should work but for some reason it keeps erroring.

DoCmd.OpenReport "Test", acViewPreview, , "Year([date])=" & Me.txtyear & " AND Month([Date]) = " & Me.txtmonth

no i don't want this

i want to count "s"

look at the report in the DB

thanks

[June7]

Saw it, didn't realize that was the issue.

I can't get the report to open.

The field with s value is not included in the report's RecordSource. You want summed by employee for each month?

The id field in Table 1 should probably be an Autonumber datatype.