Find particular records

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

Resolved · Medium Priority · Version 2003

2 posts

ReplyFri 11 Dec 2009, 13:44Delegate Sue said...

Sue has attended:
Access Introduction course
Access Intermediate course

Find particular records

We have a contacts-based database. If I wanted to find a particular individual (not knowing what company he worked at) how could I do it? The Find and Replace worked only for finding companies, not an individual.

Thanks

Version	Date	Location	Places available	Book	Next place rate (£)
Access VBA 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 24 + Thu 25 Mar 2010	Southwark	8		£445	£450
2003	Wed 5 + Thu 6 May 2010	Bloomsbury	10		£275	£280
2003	Mon 28 + Tue 29 Jun 2010	Bloomsbury	10		£275	£280
2003	Wed 4 + Thu 5 Aug 2010	Bloomsbury	10		£275	£280
2003	Thu 9 + Fri 10 Sep 2010	Bloomsbury	10		£275	£280
2003	Wed 27 + Thu 28 Oct 2010	Bloomsbury	10		£275	£280
Full Schedule: See all 7 Access VBA course dates. Bookings currently available until 6th December 2010.

748 posts

ReplyFri 11 Dec 2009, 13:52Trainer Stephen said...

RE: Find particular records

Hi Sue

Thanks for your question

I am assuming that you have listed multiple individuals per company. If this is the case then it all depends on the structure of your database

If the individuals are stored in their own table you could build a form based on that table and use find and replace there. Alternatively, you could build a parameter query that does the same thing.

If however they are stored in multiple fields within the company table, then the problem is more complex as you would have to build a query that looks at these multiple fields

Regards

Stephen

Fri 18 Dec 2009: Automatically marked as resolved.

· MS Access can promote teamwork
· Tips for designing databases in Microsoft Access
· Mining For Data With Access
· Access Corruption Avoidance Tip #2: Avoid Dangerous Data
· Access Corruption Avoidance Tip #1: Split Your Database

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

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips