To get the most recent few records (or 1 of course) when you have a time/date stamp in the records, I use
select top 10 [whatever fields] from [whatever table] where [whatever selections] order by [whatever timestamp] desc I assume a "select top 1" would actually find all the transactions for the customer, then only return you the latest one (after the descending sort). This may not be efficient enough for your purposes, but if each customer only has a smallish number of transactions, you may not care. Dave S ----- Original Message ----- From: Dian Chapman To: [EMAIL PROTECTED] Sent: Friday, June 25, 2004 4:28 AM Subject: [ASP] Need a little "logic" Hi folks... I'm acutally working on a Word/DB Automated form...but it's the same logic. And right now that's exactly what I need... I have a CustomerTbl and TransactionTbl. (This is a DB form for a bank.) I want to be able to capture the LAST transaction so I can populate the Word custom dialog box with the details of the last transaction. What would you say is the best way to capture the last transaction info? And help with code would be mighty helpful, too! <cheesy grin> It's a OneToMany relationship between the customer table and the transaction table. I have the date of the transaction...but think it might be easier to just capture the last record for that person? Since I'll need to run a query to join up the tables to find all the transactions for that customer, anyway...I'm GUESSING that I could find out the highest record number in that query??? That would be the record for the last transaction and then I could use that to create the RS for the dlg population? My other thought is to...at the time the transaction goes into the transaction table...I'll have the customer's record available anyway...so maybe I should just capture the new transaction record number and pass that into a field in the customer table? Then...when I need that default info from the last, I could just grab the number from that LastTransactionNo field and run a query for that record? I don't know? But then...that's why I'm asking the experts here cos' I'm somewhat at a loss for what might be the most sensible route to go. Note...that this is just a Word form passing data between a simple Access DB...no SQL or transaction server involved here! TIA... Dian ~ (And yes Ray...I know I owe you a reply about another matter...I'm working on it!) --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.710 / Virus Database: 466 - Release Date: 23/06/2004 [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
