Access records

D

Dave

I created a datbase for an archery tournament. Is there a way to easily
delete last years scores so I can start clean again this year without
deleting each score individually.
 
B

boblarson

If you designed it properly to begin with you wouldn't need to delete
anything and could just move forward. But, barring that, you can just open
the tables and click the top left square where the columns and rows meet,
which should select all of the records and then hit your delete key
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
 
D

Dirk Goldgar

Dave said:
I created a datbase for an archery tournament. Is there a way to easily
delete last years scores so I can start clean again this year without
deleting each score individually.
Click to expand...


Yes, you can execute a delete query agains the table that contains the
scores. You can build such a query in the query designer, without knowing
any SQL at all; but the SQL of such a query might be something like this:

DELETE FROM TournamentScores;

Although, if the query designer builds it, the SQL will look like this:

DELETE * FROM TournamentScores;

It amounts to the same thing.

The open question here is whether the table contains any records that should
*not* be deleted. Does your table have scores for multiple years? If so,
you may not want to delete them all, in which case you'd need to apply
criteria to the delete quer to delete only records for the year you want to
get rid of. On the other hand, if your table is set up with a
TournamentYear or TournamentDate field, so that it contains records for
multiple years, then there's probably no need to delete the previous year's
records anyway.
 
Top