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!
-
Tough query problem, at least for me.
I might be making more of this than it really is but here goes. I have a quote db that accumulates quote information. Since traditionally we get x% of our bids, this tool should provide some useful information. A quote will have a duration, meaning, if we get the deal, how long will we be...- tomcmp
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
nz( ) & Formatting as currency.
Can't seem to figure this out. I'm using the following in a query January Sales:nz([jansales],0) It works great for replacing a null with a zero but I can't seem to do anything with the formatting. I'd like to format as currency. Right now I would get 34568 instead of $34,568 Can somebody...- tomcmp
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
MAS-90 v. MAS-200; Number of Users
MAS200 formally MAS90 Client Server is designed for systems from 10- 200 users. The largest system I have seen is 55 users however. MAS90 is typically recommended for 1-10 user systems. There are other differences as well but that's typically the rule of thumb with regards to # of users...- tomcmp
- Post #3
- Forum: Sage 100 ERP (fka Mas90/Mas200)
