Search results
-
A
Conditional Formatting
That is great that seems to be working fine. But the system is some what getting more advanced. It is now changed into a stock control system. I now have colour, stock and minimum stock level. What i would like is for the colour in the minimum stock level to change, but only when minimum... -
A
Conditional Formatting
Hello, Im trying to use conditional formatting in a text box on a form. What im trying to do is that conditional formatting changes the colour of the text in the text box. I need the conditional formatting to look up another text box. This is what i need: i have one text box which is called... -
A
giving totals in a report
Hello, I have a stock control database system. Im trying to produce a report of the stock levels we have. At the end of the report i would like to be able to give a final total of stock. By this i mean, adding up all the stock we each item and giving a overall stock for it. For a example we... -
A
Adding up two values and displaying it in the same table
SELECT SUM (number1, number2) as "total" FROM stock that is what i have tried to use. i have also just tried =Sum([number1]) + ([number2]) but that didnt work -
A
Adding up two values and displaying it in the same table
yeh number 1 and number 2 are the field names in the table -
A
Adding up two values and displaying it in the same table
i have used this, SELECT SUM (number1, number2) as "total" but i still cant get it to work. can you please help. -
A
Adding up two values and displaying it in the same table
i have now created a query but it still wont work. For the total i have used this, "number1"+"number2" number 1 and 2 are the field names i have used. But it still wont add the two values up that there in those columns. What do you suggest? -
A
Adding up two values and displaying it in the same table
Hi, Im trying to create a database for a stock control system. I have a slight problem, the stock is in two places. So what i have to do is put in the values of stock in each place and then display the value of those two added up in the table. What is the best way to be able to do this?