Help DB Pros!

Hi All,

I need you guys help on this one. I have a form that captures customers. There is a command button to opens up a report for that specific customer of their expenditures (it runs off of a query filter). Some customers have expenditures; some are new ones that have no expenses yet. Since I have over 10K customers, instead of clicking the command button for each record in the form to find out if the customer has expenses with us or not, how do I create a textbox that will tell me that if I have records in my expenditure report, then YES, if not then NO. This will save time in clicking for review purposes.

Thanks in advance guys and I hope I didn’t confuse anyone.

Caliboi