Search results

Thanks jdraw, here is my final working solution based on your code =-Int(-Sum([Category1]="C")*-1/21) This works a treat. Many many thanks to all who posted help. Templarman

Hi there Bob, Thanks for getting back to me on this one. I copied and pasted your code into the control source and got an error. I am not sure where the problem lies. Thanks btw Bob Templarman

Thanks Anakardian and bob fitz for both of your replies. Unfortunately neither worked. Anakardian: I had to change your formula slightly to =Int(-100*(Sum(([Category1]="C")*-1/21))/-100) - I changed your original [ to ( and added another at the end. Access accepted this but still only returns a...

Hi guys, I have a problem which I hope someone could solve? I am using Access 2007 and on a form I have a calculated control which takes a number of people and divides this by 21. This is so postal labels can be produced; 21 to a sheet. The control source states...

Hi everyone - I just joined the Access World Forum and thought I would say hi. I've been using Access for a number of years but being self-taught it can be a bit chaotic sometimes. I am hoping that some of the many users on here can give me advice and help? A huge tanks to all in advance...