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.
Hi, I'm new to Access.
I'm trying to do a very simple thing but I can't.
Let's say I sell a lot of cars, every day so I need a database only to collect info about selling. I need a table (SoldCars) which need refers (read: field) to 2 other tables: 1.Constructor and 2.Model, or only to Model (because Construvctor could be redundant). Anyway, when I register a new sold car, I want a menu in which I can find a Model but not after having chosne the Constructor, so when I choose "Ferrari" then I can only find "Testarossa" and "GTO" and choose one of them. Stored field can be Model, because Constructor is implicit. But I need this tip because let's say I sell thousands of cars per day and I want it to be very quick. Please help or I'll die under piles of cars!
Thanks!!!!
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
I have a two-column list box where the user selects multiple Test Names and Test Measures. Through VBA, I loop through and create a string of the selected items and store into two seperate variables, one for each column. I concatenate with the "In" and some parenthesis to end up with the following:
In(ELA,MEAP,Star Math)
In(DRA, Math, PercentileRank)
I place each of the In statements into two seperate dummy text boxes on the form. Then I point the query criteria to these text boxes.
When I run the query, I get nothing. However, if I copy and paste the In statements above from the text boxes directly into the query criteria, I get the desired results.
I changed the code to create an "Or" statement (e.g. "ELA" OR "MEAP" OR "Star Math"), but still the same issue.
why the query will not read from the text boxes on the Form?
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
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
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