Hope we can help!

Access: Ever try to do an aggregate in a form footer and it comes back with #Error? I pulled my hair out for years trying to figure this out. Say I wanted to have "=sum(myfield)" in a text box in a form footer. I know the data type is correct as well as the syntax, but it consistently returns an error. Lo and behold guess what the fix is - If the name of the text box is the same as the name of the field that you are aggregating it fails....I think this is a Bug, Bug, Bug! Soooooo.......Change the name of the text box so it is not the same as the underlying field. Example of fix: "=sum(myField)", Change Text Box Name to: "myFieldYo" from "myField"

Database getting slow? Some quick enhancements to get it moving again: 1: Split out the Database into a Front end and Back End 2. In the Back End Index your tables and create relationships, especially those that enforce referential integrity. 3. Always have a Primaty Key for all tables, even if it is an autonumber.