If any joins are text to text, the query won't update, even though it works as a select query. Also a join to autonumber must be type "long integer"
In Access 2000, you can use the "round" function exactly as you do in Excel: =round([Field],2) in a text box or query returns the value of [Field] rounded to two decimal places.
Two points: You can write this exact same formula into the underlying query. This is very handy when it will be used in more than one object and/or the requestor changes what information they want in it.
2nd, I've found that Access will return "error" on a correctly written...
What is the program you are using to automate the process? I only have about a dozen users but my database inflates ridiculously every night. Appreciate input.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.