Setting Criteria in an Unbound Text Box with a wildcard character

[pac38]

I am trying to count the number of records in a report using an unbound text box using a field name with a criteria using a wildcard, but it still counts all the records ignoring the criteria. Any ideas what I could be doing wrong????

Looks like this: =count([field] like"7*&quot

 

[Golom]

That's the problem with "Count" it counts the number of records in the query regardless of what you use as the argument to count. The only difference between "Count(*)" and "Count(tbl.Field)" is that the first one counts nulls and the second doesn't. In your case, it is counting every record. If you want the count of field values matching "7*" then your underlying query needs to specify

WHERE [field] LIKE "7*"

 

[pac38]

Thanks, thats what I thought but wasn't sure.