Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: matteaster
- Order by date
-
Davg returns strange character
Ok my code was fine EXCEPT I forgot that dates are surrounded by #'s in SQL. The the really real code should have looked like this: prcRating = DAvg(vepField, tblName, "[Date] BETWEEN #" & TextFromDate2 & "# AND #" & TextToDate2 & "#") Just in case anyone goes stupid like i did, they can...- matteaster
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Davg returns strange character
oops, i think I answered my own question. That character must somehow signify Horizontal Tab which a following line of code changes the variable too if it is Null, now i just have to find the reason its null? Thanks for you time, Kinda sorry I posted anything now ><.- matteaster
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Davg returns strange character
Just as i thought the forums won't display that character which should have appeared where the ? is above. Sorry.- matteaster
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Davg returns strange character
prcRating = DAvg(vepField, tblName, "[Date] BETWEEN " & TextToDate2 & " AND " & TextFromDate2) returns the asccii character #218: "?" or at least that is what it looks like to me. Any help is appriciated!- matteaster
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
