I'm running a query in which I'm pulling data of an AS400 system. The table I'm pulling from has probably about 5 million records in it dateing back to early September. I've been running an append query that took about 4 to 5 minutes to update everyday but has now gotten to the point where it's taking hours to do. The update is just looking for certain fields in which the date [THDATS] is equal to a text box date (usually date()-1). I know an append query probably isn't the best way to go about this but would anyone have any suggestions as to how I can just pull the dates I need from the table in question in a quciker manner? I can provide more information if possible. Thanks for your assistance.
Brad
Brad