Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Deleting Multiple Records in Microsft Query for Excel Import

Posted on 2012-08-17
Medium Priority
Last Modified: 2012-12-02
Deleting Multiple Records in Microsft Query for Excel Import
Asked by: Yemi7 Hi All,

I'm running a query that will return data containing samples from vet practices and i have information on vet practice, client, animal, owner , sample code, test codes etc. i have run the query but it's supposed to have 63 records but it's giving me 8192 records, i have done a criteria  to select only the test codes i want, how can i delete the multiple records? thanks
Question by:Yemi7
  • 3
LVL 77

Expert Comment

ID: 38305571
It's not clear how you are creating this query or even which product (Access or Excel) you are using.

But we shall need to see the details of the query before being able to provide a proper answer.

Accepted Solution

Yemi7 earned 0 total points
ID: 38312019
thank you, i have now fixed this, it was the links that caused the multiple records


Author Comment

ID: 38635722
now working

Author Closing Comment

ID: 38652081
thank you, i have now fixed this, it was the links that caused the multiple records


Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question