Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-14-2018, 09:08 PM   #16
bsk13
Newly Registered User
 
Join Date: Sep 2018
Posts: 11
Thanks: 4
Thanked 0 Times in 0 Posts
bsk13 is on a distinguished road
Re: How to get rid of double records (SQL) - HELP!

Thanks! I tried the query, and unfortunately I get huge performance problems (first page after a while, then the screen locked "for ever").

Do you think there is a way to write the query to come around the performance problem?

Many, many thanks for all the time you spent on my topic so far!!

bsk13 is offline   Reply With Quote
Old 09-14-2018, 10:32 PM   #17
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,603
Thanks: 55
Thanked 2,098 Times in 2,009 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: How to get rid of double records (SQL) - HELP!

you know if the final step as you suggest in post #9 that the final is excel, you do not need to involve msa. just use excel. consolidate all sheets into one. select all columns. sort by partno and date. remove duplicate (by partno). then youre done.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is online now   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
bsk13 (09-14-2018)
Old 09-14-2018, 11:15 PM   #18
bsk13
Newly Registered User
 
Join Date: Sep 2018
Posts: 11
Thanks: 4
Thanked 0 Times in 0 Posts
bsk13 is on a distinguished road
Re: How to get rid of double records (SQL) - HELP!

Thanks for the fast reply. The table "orders" is not just sent back to Excel. It is joined with some huge table in our datawarehouse and used for several reports. Therefore it has to be in Access. Hmmm... this is really difficult.

bsk13 is offline   Reply With Quote
Old 09-14-2018, 11:27 PM   #19
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,603
Thanks: 55
Thanked 2,098 Times in 2,009 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: How to get rid of double records (SQL) - HELP!

suggest you do it first in excel, much simpler.
after coming to the final result, 1 record per partno+max date, then you can
create a link table in msa and use this link table instead of building a slow query.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is online now   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
bsk13 (09-16-2018)
Old 09-16-2018, 12:24 PM   #20
bsk13
Newly Registered User
 
Join Date: Sep 2018
Posts: 11
Thanks: 4
Thanked 0 Times in 0 Posts
bsk13 is on a distinguished road
Re: How to get rid of double records (SQL) - HELP!

Hi. Thanks again for your suggestion and all your effort in this thread!
To do it in Excel is not really easy. Seven independent (similar looking) "order files" are updated by different users spread over the company. MS access links to these seven and creates an aggregated report. All reporting works dynamically "on-demand" for the users. Therefore it must work without any "manual steps" bu "super user". Perhaps there are no possible MS Access solution that will meet the demands I wrote on in earlier posts (like no macro, high speed etc), and I instead have to re-think the concept or think somehow unconventional...

bsk13 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
help with preventing double records Rusty1969 General 1 12-02-2012 08:15 PM
queries are returning double records Jason1 Queries 4 05-29-2012 03:19 PM
Adding Records with double click honor401 Forms 2 09-10-2004 12:03 PM
Double Records jamesT General 1 04-08-2003 01:26 PM
combobox with no double records RobJ Forms 2 03-07-2003 06:52 AM




All times are GMT -8. The time now is 04:33 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World