Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 25th, 2003, 11:49 AM
Registered User
 
Join Date: Jun 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Updating

I have a database of checks issued. I would like to import the bank data to update the table to show that the checks have been paid and then to generate an outstanding check report. The bank data has check number, paid date, and paid amount. The check number is the key field. What would be the best way to move the paid check data into the table? There are 8-10,000 checks per month, so I would prefer not to have two separate tables, which are joined, but to update the main table.
 
Old June 25th, 2003, 05:41 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If you really want to have all the data in the same table, then I think you've already answered your own question - i.e. "update the main table"

Just make sure that you have the fields in the main table, and run an update query.

Steven

There are 10 kinds of people in the world - those who understand binary - and those with friends





Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating a datagrid jgrant ASP.NET 2.0 Basics 0 August 25th, 2007 07:34 PM
Updating Labels in C# dranne C# 3 April 10th, 2007 12:37 AM
Updating Recordset arholly Access VBA 16 December 27th, 2006 01:28 PM
database not updating ellie BOOK: Beginning ASP 3.0 1 April 16th, 2006 05:28 AM
updating many to many whyulil Classic ASP Databases 4 March 11th, 2004 12:58 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.