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,984
Thanks: 56
Thanked 2,231 Times in 2,141 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 offline   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,984
Thanks: 56
Thanked 2,231 Times in 2,141 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 offline   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 11:15 PM.


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

Featured Forum post


Sponsored Links


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