Search results

I have a database with a large amount of data that is updated quarterly. We need to generate reports that are based on three time periods and print reports with the dates in the column labels. The data are extracted with a query, manipulated through a number of other queries using Period1...

Thanks to both of you -- I changed the function to ACOS and that solved the problem. I knew I was doing something stupid............... This was the first time I had directly coded any kind function, so it was a real learning experience and I really appreciate your help.

The function seems to compile properly if I go through the Debug/Compile process, but when I test it in the immediate environment it fails. There is no indication of a failure in any specific line of code. There is just a Microsoft Visual Basic box comes up with: Compile Error: Expected...

Everything is computed in radians and the returned value from the query calculation is less than 1. To test the module in the immediate environment, the entry I made set a value for the cosine as 0.75 as follows: ?ArcCOS(0.75)

I have a query in an access 2007 database that returns a numerical value for the cosine of an angle. I need to transform that value into the angle itself but there is no ArcCos function in Access. I have created a new Module, which I named ArcCOS to do that but when I test it in the Immediate...