Want Access to return "Yes" if any of "Service Dates" fall in August

[claysea]

I have a main client table with a linked services sub-table. I want my report to indicate a "Yes" if a specific client had any services for August and "No" if they haven't. Some clients will have 8 services for August and some will have none. I have researched to my wits end and came up with a bunch of duds. This was my latest disaster (all the answers returned were No...and that is not true).

=IIf([Date of Service]=Month(Now()-1),"Yes","No")

[June7]

Could try domain aggregate function, like:

=IIf(Not IsNull(DLookup("[ClientID]","tablename","ClientID=" & [ClientID] & " AND Month([Date of Service])=" & Month(Date())), "Yes", "No")

or

=IIf(DCount("[ClientID]","tablename","ClientID=" & [ClientID] & " AND Month([Date of Service])=" & Month(Date())>0, "Yes", "No")

When will you run this report? If you run it on 1st of month do you really want to search records for the previous month instead? If you want to be able to run the report IN any month FOR any month, then need dynamic input parameter to filter the report and for the domain aggregate function.

[ssanfu]

What does the data in [Date of Service] look like? Is it a date?

Today, Month(Now()-1) will equal 10. Is that what you want or do you want August?

If you are looking for records in last month (from this month) and [Date of Service] has dates , I would try:

=IIf(Month([Date of Service]) = Month(Date()-1),"Yes","No")

(Also, you shouldn't use spaces, special characters (except the underscore) or reserved words in object names)