I am having an issue with updating a table based on a form. My database contains tblInfo, tblData and tblWarranty. I have a form which contains 2 serial numbers([serial1], [serial2], they are both in tblInfo and tblData. I need to update tblWarranty with a mixture of information from the others. Now heres the part I am stuck on, I need to use form.[serial2] to get tblData.StartDate, then use form.[serial1] to get tblInfo.In and tblInfo.Out. These 3 dates will be used in this equation: ([Start]+(365/12))+([Out]-[In]). The table warranty needs to be appended with [serial2] in tblWarranty.ID and the result of the equation in tblWarranty.Date. I have tried to use an append query, but it does not seem to like having more than one criteria, and results in appending 0 rows. Any ideas on another approach to this situation would be greatly appreciated.
Thanks, Chad ------------------------ Yahoo! Groups Sponsor --------------------~--> See what's inside the new Yahoo! Groups email. http://us.click.yahoo.com/3EuRwD/bOaOAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
