Search results

The end goal is to get the function to calculate the result for each record. The current method works fine, so I suppose I will stick with it. Thanks.

Yes, that sounds right. The values are always from the same fields in the record. Because I will need some VBA that will need up to 8 fields and alot of If's I was hoping that there is way to hard code them into the VBA as it is easier to read and modify if needed.

I don't understand the question. The table with the data is in the query.

I have a simple function: Public Function DayY(ByRef Var1 As Variant, _ ByRef Var2 As Variant) As String Dim nDayY As String If IsNull(Var1) And Var2 = "Yes" Then nDayY = "Yes" Else nDayY = "No" End If DayY = nDayY End Function...

Thanks, I was hoping there was an easier way as in total I need to use 6 columns.

Sorry there is a mistake in the prev code. Should be: var1 = [table1]![col1] var2 = [table1]![col2] I need the code to calculte the result for every row, not a specific one.

I know tha this is basic but I can't figure it out as I am a novice. I am trying to get some code so that when I I just Put expr1: Func() into a field it will come back with the needed result. I have come up with: Public Function Func() As String Dim temp As String Dim var1 As...

Thanks. I had a feeling that this might be it, but didn't fully get it until I read the article.

Workdays([Start Date],Date()) or Workdays('01/05/2013',Date())

I'm trying to work out the number of working days between 2 days (eg 01/05/2013 & today). I found the following code: ' Weekdays Function Public Function Weekdays(ByRef startDate As Date, _ ByRef endDate As Date _ ) As Integer ' Returns the number of weekdays in the period from...