Recent content by KenshiroUK

Hahahah That worked cheers!!!

Thats almost worked! Thank you. I'm having trouble because of the duplicate country names with different zip_low, zip_highs. it now returns the data as many rows as the country names within extended ares table. For instance if I have United Kingdom 3 times within my tbl_extended area. I I will...

http://www.access-programmers.co.uk/forums/showthread.php?t=252995

Okay I believe an IIF statement would probably do it. If I can tell ship-postal code to look about tblExtendedAreas zip_low => And =< zip_high IIf("[extended]","Y","zip_low>='" & [ship-postal-code] & "' AND zip_high<='" & [ship-postal-code] & "' AND country='" & [ship-country] & "'")

Sure that would help! ExtendedArea: DLookUp("[extended]","tblExtended_Areas","zip_low<='" & [ship-postal-code] & "' AND zip_high>='" & [ship-postal-code] & "' AND country='" & [ship-country] & "'")

Thank you for code yesterday, however it seems to have completely slowed my database down. Is there an alternative method?

Yesterday I kind fellow here gave me a piece of code for a dlook which has worked fine. However Since pasting it into a query, it has completely slowed my database down. Is there an alternative for this? I basically have 2 tables, one with customer details etc, a second table with duplicate...

Ah nevermind it seems to have worked okay! Thanks for that.

I'll removed those links then, but as your can see it gives you a lot of those countries, but if you click on the extended field within the query and click A-Z , you'll notice many of those disappears!?

Okay, because this is really bizarre. As you will see, Query1 works fine, but if you have a look at the second query you'll see what I mean.

I see that has worked! How would I get around this duplicate countries, but with different zip_low, zip_high? I mean I have a list with Argentina for example quite a few times with a list of the different postcodes in zip_low, zip_high.

Hahaha thank-you! It worked perfectly. Now just a quick question is there a way to reverse it so, when a run both intended queries, one gives me a list of extended like we've got and the other gives me a list without? I also notice the DLookup is running very very slow.

Okay, if you go to 'Create' and you'll find at the end 'Query Wizard'. Click that and then you'll see "Find Duplicates Query Wizard". Click that and run it'll return any duplicates, which you can delete. Make sure you back up table before just in case, but I'm fairly sure that will work.

Hi, thank you for the code. This has partly worked as I matched country to country, however it has returned everything single line of Argentina, duplicated over and over again. It could be partly due to the duplicate country names, or codes? I've just tried 'Group By' and its removed...

I've attached a copy as well. Since I've been puzzled over how to write this query.