Printable View
I'M TRYING TO ESTABLISH A PROGRESS REPORT IN ACCESS 97.
I CREATED A DROP DOWN LIST IN 1 FIELD THAT I WANT TO READ AND ASSIGN A % COMPLETE VALUE IN ANOTHER FIELD.
FIELD1:= STARTED
FIELD2:= 45%
THIS WOULD HAVE SEVERAL GRADUATION UNTIL 100% IS REACHED. CAN THIS BE DONE WITH A EXPRESSION OR IN ACTUAL VBCODE.
THE DATABASE IS ACCESS.
THANKS,
Err.. Not quite sure what you mean.
You have one, numeric value in a field, and you want to find that same value as a percentage of a total value - is that right?
Sorry, you seem to have explained it in clear words, but I don't quite understand. You said about graduations in the percentage - How will you calculate the percentages?
ACTUALLY I HAVE TEXT THAT DESCRIBES A WORK FUNCTION IN THE FIRST FIELD.
I THEN ASSIGN A WEIGHTED VALUE FOR THAT FUNCTION THAT IS REPRESENTED AS A % VALUE. THERE WILL BE SEVERAL WORK FUNCTIONS THAT WILL GRADUATE UP TO 100% COMPLETE.
IT LOOKS LIKE THIS IN EXCEL BUT I HAVE NOT BEEN ABLE TO FIX THE SAME TYPE OF FUNCTION IN ACCESS.
=IF(F4="STARTED","45%",IF(F4="CHECK","70%"))
ALL THE WAY TO 100%.
I'm a bit rusty on Excel but that looks like:
If F4="Started" then
value="45%"
Else
If F4="Check" then
value="70%"
End If
End If
Is that any help? If you were just trying to figure out the VB code for what you have in Excel then I think that's right. I expect there's equivalent Access code, but since I have always avoided using Access I wouldn't know :)