trouble starting code

[Robeen]

1. Why do you have the words "Final Cut" & "First Cut" in that field?

2. I was thinking of the function looking something like this:

 
Function Get_Cut_Number(CutNumber As String) As String
'CutNumber as String is the value of Cut_No from your Table passed in from the query.
'"As String" at the end of the Function Name is saying that what is going to be Returned is a String.
 
Dim Result as String
 
If CutNumber = "Final Cut" Then
   Result = 11
Else If CutNumber = "First Cut" Then
   Result = 1
Else
   Result = CutNumber
End If
 
Get_Cut_Number = Result
 
End Function

In your Query, you'll have a field that looks something like this:
Cut_Number: Max(CInt(Get_Cut_Number([Cut_No])))
and in your Criteria you'll have > 10.



What that will do is for each row of data, it will send the Cut_No value to the function and then put in whatever the function returns.

You'll have to decide what you want to do with 'First Cut' and 'Last Cut' in the function.
The query still won't work if you have those words as values instead of numbers.

I haven't tested the above Code so there could be typos etc - but I have used this type of processing several times when I've needed specific things done to Table data in a query.

Let me know how it goes!!

[mejia.j88]

1. i just started working at this company and one of my projects is to eliminate all paperwork into electronic documentation, they are very iffy when it comes to changing things (as little as it may seem here, with final cut=11), i'd rather keep things as close as possible to how they are/were.

2. i'll play around with this a tiny bit if it doenst work, i'll let you konw when i get it working.

thanks so much for your help Robeen,
you deserve xmas cookies and treats for your kindness.

[Robeen]

I understand about them not wanting anything changed.

The code I gave you should at least give you an idea of one possible way to get what you need.

I hope you're able to figure it out.

Let me know if you are able to get it going or if you have problems.

All the best!