Replacing data

The UK's most regular instructor-led training courses.
Training information: microsoft database training · Microsoft.access.courses · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Urgent Priority · Version 2003

4 posts

ReplyFri 13 Nov 2009, 10:44Delegate Xing said...

Xing has attended:
Access Introduction course
Access Intermediate course

Replacing data

Hi,
In my database, I need to replace a huge amount of data in one field. I wonder if there is a quicker way to replace them all, e.g. using a query?

Thanks. Looking forward to your reply.

Regards,

Xing

Version	Date	Location	Places available	Book	Next place rate (£)
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Fri 19 Mar 2010	Bloomsbury	4		£235	£240
2007	Wed 24 Mar 2010	Bloomsbury	5		£240	£245
2003	Tue 6 Apr 2010	Southwark	9		£203	£208
2007	Thu 13 May 2010	Bloomsbury	7		£188	£193
2003	Tue 18 May 2010	Bloomsbury	9		£182	£187
2003	Fri 2 Jul 2010	Bloomsbury	7		£85	£90
Full Schedule: See all 11 Access Advanced course dates. Bookings currently available until 14th December 2010.

755 posts

ReplyTue 17 Nov 2009, 09:18Trainer Stephen said...

RE: replacing data

Hi Xing

Thanks for your question

The quickest method would be to use an update query which can be used to replace specified data within a given recordset.

Can you clarify the following for me so I can be more precise

1. Does the new data exist in some electronic form (database or
spreadsheet)
2. Is the data to be replaced in 1 or multiple tables

Thanks

Stephen

· Three Myths About Microsoft Access
· The Benefits of Certified Microsoft Training in Access
· Access And Its Uses On The Web
· Access 2007 Is All About Systems!!
· Use Microsoft Access to manage your work/life balance

Please browse our web site to find out more about
microsoft database training and other Microsoft training courses.

Access tip:

Combo box for finding records

You can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it

View all Access hints and tips