Woot i got it! Now that i have the update query set up i will be modifying about 13 fields at once each will have around 700 records should i run 13seperate queries or 1 big query since they will all have to be modified. Also what is the best way to modify records as thgey are recorded like as...