hi Dian, use the following query this might help ur problem update Referral.Sale=True , Referral.SaleDate=Now() where Referral.date=date()
"Dian D. Chapman" <[EMAIL PROTECTED]> wrote: Hi folks� I'm working on a Word form with ADO/DB connectivity. I'm not too bad with these, but this one has a slightly complex listbox and I could use some help trying to figure out how to get one of the processes sorted out. (Hope I can explain what I need�) It's a banking form and Access DB w/3 tables�Teller, Referral, Customer�the Referral table has both the CustomerID and TellerID to act as the JOIN table (????). Whatever it's called, it works. It'll be used to track teller referrals to customers that end in sales. When a customer's name is checked, a listbox displays all the referrals for this customer by Referral.Product, Teller.TellerID, and Referral.Date. I'm currently working on figuring out how to properly get the TellerID out of the correct column and now have it displaying in a msgbox�so I think that parts okay. But now I'm not sure how to get the next part of the query. Say I end up with TellerID = 444 and TellerID = 555, meaning that both of these tellers told some customer about checking and now they purchased that service, so both 444 and 555 should get credit for the sale. How do I update both these records. Am I missing something and this is so obvious that I don't see it? Do I query for Referral.TellerID = 444 OR Referral.TellerID = 555 to get them both into a record set and just loop through each record to update the Referral.Sale=True and Referral.SaleDate=Now() fields? Maybe I'm just been awake too long, but I just can't wrap my brain around how I can pull more than one TellerID and then update a field or two in both with the same info? I'm thinking I should to a Do Until RS.EOF and then add the info into the fields for each record??? Is that all it is. Any info would be greatly appreciated. Dian ~ -- This email scanned and certified clean by AVG! Checked by AVG Anti-Virus. Version: 7.0.289 / Virus Database: 265.4.7 - Release Date: 12/7/2004 [Non-text portions of this message have been removed] --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links --------------------------------- Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more. [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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/
