I have an unbound report named CustomerData that I am adding text boxes into to calculate certain numbers.
Within this report, I have a text box named [Text150] that I am using a DCount function in. I need it to show the number of customers within the table named "Customers" that have ordered from me during certain months. I keep that information in a field named [MonthsOrdered] within the same "Customers" table. Since there is possibly more than one month within the [MonthsOrdered] field per customer, I attempted to use a wildcard within the DCount criteria, as well as the LIKE operator, but I cannot find what I'm doing wrong.
Here is my current function for finding the number of customers who have ordered something in July:
=Nz(DCount("[CustomerID]","Customers","[Customers]![MonthsOrdered] LIKE '*July*'"),0)
I think my issue is within the LIKE '*July*' portion, but I've tried different ways of stating it and have not found a solution anywhere. I have also tried changing "[CustomerID]" to simply "*" to no avail.
I am not new to Access, but I'm entirely self-taught and not a professional Access programmer. Any and all help would be appreciated. This is a mystery I cannot seem to solve on my own.