I have another question (I assure you that I have done some search and research before asking in this forum :-) ) that seems simple but can't find help for.
I have a report with some cells and in each of these cells the data is of the form:
fraction & "(" & integer & ")"
such that I want it to look like for example: 75%(3)
Currently it would just display 0.75(3). How do I set it to display the format I want? Thanks!
You can't use format for this - you have a specific format in mind and you will have to build it up yourself. Please have another look at my post. Your expression is going to look a bit more complicated since you already have some calculations going on but that is the only way uou will be able to do it.
i did try the ROUND function but it doesn't seem to be part of the API and even the help doesn't seem to recognize this function (I am using MS Access 97). However what worked for me is CInt() which rounds of the function to the integer value.