Search results

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.

Hi, thanks for getting back to me You should create a function in a module that takes a zip and returns what you want. But you haven't given me enough information. Let's use this as your table's data: ExtendedArea Country, zip_low, zip_high, ExtendedArea Argentina, 3007, 3100, Y Columbia...

Have you tried using an append query with linked tables to combine all data into one new table? Then run query wizard to find duplicates within that new table?

So when query is ran if Argentina postcode 3008 is equal to or more than zip low, but equal to but is less than zip_high it gives me a Y

Hi all I have 2 tables, one called Addresses and Extended Areas. Within my imported orders I have addresses with postcodes and countries. My Extended Areas table has Country, zip_low, zip_high and extended area with a Y. I wish to check certain postcodes from a particular country between...

Hi jdraw, I do apologise for the amount of posts I have created when relating to this project I am working on. A while ago I was asked to create a fully functioning orders database for my manager. I am a novie as you probably have guessed with the amount of related posts when it comes to access...