I am building a couple of SQL-Selects to return the total sales by customer (one for LastYearSales and one for YearToDateSales). The return will be in a textbox on a customer info form. There are a low number of users <15 and the info is accessed a few times each day by 10 or less users.

My question is, do I narrow the query to just the customer whose info is being viewed or have the query return info for all customers to a cursor or array and set the textbox source to the appropriate record?

If the return is for one customer should that go to an array or directly to the textbox?

So far I have built the query to return the total for one customer but have not tested it. I'll be doing that next.

Query runs fine, now to figure out how to put the result in to the textbox.

Actually I think I'll use the cursor approach.

TIA