Thanks for your help DES
I don't know why but the seperator in the IFF statement in my Access 97 is ; and not , as you said...don't know why this is....you might have the developer edition or something....
but it dont matter now because its solved
My first question i solved on a different...
"The first question becomes why do you want to save in a table a value which you can always recalculate later. Most people will insist this is a no no."
- Well i want to make search functions in my database and i want the search function (query) to display field C aswell....hope you understand...
Hello,
question one:
==============
I have a table with the following fields
all of the type currency
A
B
C
Now i made a form based on the same table
form looks also like
A
B
C
now i want that in field C the result will be recorded of the expression A-B
So the formula i want to use is...
I have a table whit a field "yes/No"
The defaultvalue is set to "No"
I have a form with a button
Now when i click the button i want that the the value of the checkbox change from "No" to "Yes" automatticly. Anyone know how to do this?
I have a table whit a field "yes/No"
The defaultvalue is set to "No"
I have a form with a button
Now when i click the button i want that the the value of the checkbox change from "No" to "Yes" automatticly. Anyone know how to do this?
Hello,
Lets say i want two combo boxes on my form.
In combo box oone you can select the values:
A
B
C
D
In the second combo box i want to select values which belongs by the above clicked value.
Lets's say If i click on the first Combo box A
then i want to select in the second combo box
1...