Menu
Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Access Newsgroups
Access Beginners
Newbee - how to loop through table and delete unwanted records
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Nikos Yannacopoulos" data-source="post: 1930966"><p>Adam,</p><p></p><p>How about making a new table with just the records that you want, and</p><p>then (renaming or) deleting the original table and renaming the new one</p><p>to the original name?making the new table is a piece of cake: start by</p><p>making a select query on the existing table, go View > Totals and notice</p><p>the new line headed Totals: that appears in the grid; the default</p><p>setting is Group By on all fields, leave it as is on the GroupNo field,</p><p>and set it to First for all other fields. Go to datasheet view to check</p><p>if you are getting what you wanted (which I expect you will). When happy</p><p>with it, just change the query type top Make Table (from the Query</p><p>menu), run it and you're done with making the new table.</p><p></p><p>HTH,</p><p>Nikos</p></blockquote><p></p>
[QUOTE="Nikos Yannacopoulos, post: 1930966"] Adam, How about making a new table with just the records that you want, and then (renaming or) deleting the original table and renaming the new one to the original name?making the new table is a piece of cake: start by making a select query on the existing table, go View > Totals and notice the new line headed Totals: that appears in the grid; the default setting is Group By on all fields, leave it as is on the GroupNo field, and set it to First for all other fields. Go to datasheet view to check if you are getting what you wanted (which I expect you will). When happy with it, just change the query type top Make Table (from the Query menu), run it and you're done with making the new table. HTH, Nikos [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Access Newsgroups
Access Beginners
Newbee - how to loop through table and delete unwanted records
Top
