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


ADVERTISEMENT

Maths/Percentage

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

Maths Dummy !

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

Maths Within A Table

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

Autolookup Not Working When Maths Involved

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







Copyrights 2005-15 www.BigResource.com, All rights reserved