Recent content by Tempest

Hi All, Some help from cyber space is what I need me thinks :confused:, I am using a switch function in an access query to convert 24 to 624 and 28 to 628 and so on for about 5 entires however there are numerous entries that might not meet my criteria that are errorrs can I just simply place in...

Yay It Works Thanks Bob, I ended up creating a third master table and then two append queries which gives me exactly what I need. Thanks for the point in the right direction :cool:

Hi I have Two tables with identical field names with information reagarding a physical catalogue from one site and a catalogue from another site I would like to join them utilizing there manufactorer code. And ignore all the duplicates. Any assistance greatly appreciated.

Hi All, has anybody ever had a macro to delete the first row or seen something similar, I know you can do it manually but I am trying to avoid this as dont want the user intervention their is a line of text above the table names that I want to remove and ignoring it in the first import dosent...

Dont Worry - Fixed Well dont I feel stupid..... :eek: Fixed.... Sorry to bother you!

Help I'm having the Same Problem!!!!! Hi Jen, I'm having the same problem with a database I am working on how did you solve your problem??? Any help greatly appreciated.. Cheers, Mark :confused: