Removing outdated records 1

[MaMister]

I have:

Database A with fax numbers:
Example:
- 1. John. W
- 2. Mark. Y
- 3. Sean .S

I exported to a dbf file to do some mass faxing and realised that Mark's fax number is no long in use. (error report by the fax software)

I can export the error report and save as dbf.

Is there a way to make use of this dbf to update and remove Mark's record from Database A?

 

[AlexCuse]

if you import your DBF into Access as tblError, then you could run this query:

delete tblFaxNumbers.*
from TableFaxNumbers
where FaxNumberField in
(
select FaxNumberField from tblError
)

It may take some formatting to get your fax numbers to match up.

Hope this helps,

Alex


It's a magical time of year in Philadelphia. Eagles training camp marks the end of another brutal season of complaining about the Phillies.

 

[MaMister]

Sorry, I am not so good in this.

My orignal database is fax.mdb
So I imported the error report as faxfail.mdb

How shall I go from here?

 

[MaMister]

After some formatting,

I renamed my source table with all fax number to: tblfaxnumbers

I imported the error report to: tblerror

I also created a query but don't know where to input the code.

 

[MaMister]

Thanks, after some work around, I got it working...

Thanks again.

 

[AlexCuse]

It would have been easier to just change my table names into yours. Code would be entered in the SQL view of a new query. If you aren't familiar with this, you should build some queries in design view and then look at them in SQL view so that you can get familiar with it, as SQL code is the easiest way to help someone with a query around here.

You can also check out

http://www.sqlcourse.com

or a similar tutorial, although this would teach you ANSI SQL. There are several subtle differences between this and the jet SQL used by access.

Sorry I did not get back to you sooner, but it is good that you figured it out. Good luck getting better acquainted with access, and thanks for the purple thing.

Alex


It's a magical time of year in Philadelphia. Eagles training camp marks the end of another brutal season of complaining about the Phillies.