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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Remove leading £ sign from currency field
Is it possible to perform this action with pure SQL (not being the Access engine)? I need to remove a character (the ';') from certain fields (all textfields) since it is the delimiter for an automated exportfile. Thanks!- m0TiVe
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Conditional Counting (sumproduct)
I am trying to 'port' an Excel-file to the OpenOffice suite. One thing i am struggling with is the conditional counting i 'fixed' in Excel. For example: A B C 1 yes 100 200 2 no 50 100 3 yes 40 0 4 yes 0 0 In Excel i used...- m0TiVe
- Thread
- Replies: 1
- Forum: Office suites general discussion
