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 gkittelson 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: TheComputerLady
- Order by date
-
Totals won't add up
kupe, First let me make sure I understand your situation. You have a query, qryTrimmed, which has fields named ShortUrl and Hits. Even if Hits was a calculated field in this query, you can continue additional calculations in further right fields in the same query. (I am not quite sure where...- TheComputerLady
- Post #2
- Forum: Microsoft: Access Other topics
-
acces sql query, need to change null to 0
I don't remember my vb at all well, but in an Access query you can in the QBE pane use the conditional IF statement. If the original number where you are getting nulls is called [Value], then go to a blank column in the QBE pane and type NewValue: IIF(IsNull([Value]),0,[Value]) This means...- TheComputerLady
- Post #3
- Forum: Microsoft: Access Other topics
