I have a text field (CurHrs) in a linked ODBC table that I want to change to numeric. I created a query with this table and made a new field: NuCurHrs:CDbl([CurHrs]). The field looks great. I then created another query with this new field and used the Total: Sum option on the NuCurHrs. It performs the sum great except if there are any entries <1 - then I get "Invalid Use of Null". What am I doing wrong?
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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problem w/field type change in query
- Thread starter elaineva
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question