Maths
Aug 28, 2007
Hi
I am trying to do a calculation using 2 fields in 2 different tables
I want the result to be displayed in a field so I have put this expression in the control source of that field:
=[test2]+Forms!table1!test
But all I get is #Name?
Any ideas what is wrong
View Replies
Jun 19, 2006
Hello, I'm stuggling to work out how to go about setting up a formula.
I have 497 students 186 are Male 311 are Female. How do i work out the percentage of Male and Female students? I have no idea how to do the Math behind this so cannot start to add it to my database. If anyone can show me how to calculate this it would be really helpful.
regards
Pete
View 2 Replies
View Related
Oct 26, 2006
OK, I have this formula in an excel cell that works out the change in percentage of two cells, the formula is as follows.
IF(B3=0,O3,((+B3-O3)/B3))
The cells used are B3 and 03 and the results are stored in the AA3 cell.
I am trying to write this in a text field on a report which does the same thing but i'm having probelms translating this across. Can anyone point me in the right direction ?
Thanks in advance, Mitch.
View 1 Replies
View Related
Oct 2, 2006
Hi
sorry if this is a dumb request....
I have a table in which I store: 'cost price' , 'sell price' & 'Profit'
what method can I use to automatically populate the 'profit' based on the entry of 'cost' and 'sale' price???
Thanks in anticipation
View 2 Replies
View Related
Jun 16, 2006
I have an autolookup that changes the numbers 2, 4 and 6 into P, M, and D so they look easier for my purpose. However, when I use a select query to find the max number for each criteria it shows a number not the letter. Do lookups stop working when you apply maths or can i change this.
View 6 Replies
View Related