Thank you very much. I really appreciate you taking the time out of your busy schedule to help a novice like me.
It worked perfectly. R:Base is the best. David C. Gideon Controller/Treasurer Builders Supply, Inc. 8198 E 44th Street Tulsa, OK 74145 Tel: 918-628-1211 Fax: 918-627-3710 From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: February 26, 2014 8:02 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: amateur David, You do not need a table. You need a view. Here is a command that would create your view, if you typed it at the command line: Create View LatestInvoices (CustNo, LatestInvoiceDate) + AS SELECT + CustNo, MAX(InvoiceDate) + FROM YourTableName + GROUP BY CustNo Then you will have the equivalent of a table, but it will always be up to date. You can use it in a lookup, you can base a report on it, you can browse it. Bill On Wed, Feb 26, 2014 at 8:52 AM, David Gideon <[email protected]<mailto:[email protected]>> wrote: I have a table that has the following columns. Custno Invoiceno invoicedate The table lists all customers and their invoice numbers and invoice dates. I need to create a table that has Custno and the latest invoice date for that Custno. I am trying to use a command file to do this, but have not been able to find the correct commands. I would appreciate any help you can provide. I have never used the R:Base list before so if I am not doing this right, please let me know. Thanks David C. Gideon Controller/Treasurer Builders Supply, Inc. 8198 E 44th Street Tulsa, OK 74145 Tel: 918-628-1211<tel:918-628-1211> Fax: 918-627-3710<tel:918-627-3710>
