matteaster
Technical User
Code:
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!
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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Davg returns strange character
- Thread starter matteaster
- Start date
- Status
returns the asccii character #218: "?" or at least that is what it looks like to me. Any help is appriciated!
- Thread starter
- #2
matteaster
Technical User
Just as i thought the forums won't display that character which should have appeared where the ? is above. Sorry.
- Thread starter
- #3
matteaster
Technical User
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 ><.
- Thread starter
- #4
matteaster
Technical User
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:
Just in case anyone goes stupid like i did, they can search this post and maybe find the answer before posting like I did.
Code:
prcRating = DAvg(vepField, tblName, "[Date] BETWEEN #" & TextFromDate2 & "# AND #" & TextToDate2 & "#")Just in case anyone goes stupid like i did, they can search this post and maybe find the answer before posting like I did.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question