Search results

Thanks everyone, Yes "X" was total days.

I've set up a database for a friend who owns a workout center. The only thing I have left is to set-up a formula in the query to find out the average calorie intake daily. (Find the Median) I'm thinking something like: Average_Cal_Intake: [End_Day_Calories]\X My problem is "X", how do I make...

Amazing, this is exactly what I was looking for! Thank you to no end once again, you've saved me from an expensive bar tab tonight!

If I may borrow your knowledge for one more thing. I would like to set up a "Before Update Rule" in the "Zip" field so that people cannot enter the full zip code anymore. The problem is We do have Canada addresses as well so simply only allowing five digits in the field wont work. My question...

Brilliant !!! Thanks again!

I am extremely new to this. What is the exact code I enter in "Update to" ? The comma keeps coming back with errors and if I enter " " around the code its turns it into text to fill the box in with my coding.

I tried what you said and it worked but its just an illusion (As you stated). I was hoping to "Clean up" the current data as well though, with a simple update query. Thanks Again.

We have a mailing list with 83,000 names in it. Our problem is we need to send it to our printers without Full zip codes "55555-5555". I ran a query to find the incorrect format entries. "*****-****" and came back with 43,256. Now I need to do an update query to change them to a five digit...