-- snip --
>p.d.
>
>does anyone else use sundays to catch up?
----- reply -------
Dear Alfred:
Everyone I know works at least part of the weekend. I don't know how much "catching up" is going on. Trying not to fall further behind is more like it.
As to your query... There is little question IMHO that SQL Select is the most elegant way to total invoices into a statement. More importantly, it also provides a very sparse means of gathering all of the separate invoices that make up a statement if you want to provide your customers with a detailed statement. Select for the customer and included dates into a cursor, and print your statement from the fields in the cursor -- using the cursor as the source for your statement report. Try it, it is very quick and requires very little coding.
I believe there is a very good article on using SQL Select in the UT knowledge base -- "Using FoxPro's SQL to query DataBases" is the title.
If you are careful to select on your indexed fields, selecting from a 100,000 record data base is virtually instantaneous.
Regards,
JME
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.