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!
-
Count instances of character in a query
PHV: Thanks alot, that seemed to work! I had played with replace and len, but I was I didn't think of that. Les: I agree, and if I was designing the db in a rational manner I would to another table to store the dates, but the user said no to that and the user is also my boss so dates in one...- gtenney
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Count instances of character in a query
I've been pondering and trying various things, then searching but I still haven't been able to find an answer. My question is this - I have a user who wants to store multiple dates in one field, then count the number of dates in that field. The dates would be separated by the same character...- gtenney
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
-
PRI and Line Pool
That's what I have done for now, but I was hoping I could add it to the line pool OR make it the default route. In my experience at this company, it has often been easier to change the system behavior than that of the users ;-)- gtenney
- Post #3
- Forum: Nortel: Norstar systems
-
PRI and Line Pool
Is it possible to either add PRI lines (or the whole PRI) to a Line Pool *or* add the PRI to default route? Situation: We recently had a vendor add a PRI to our Norstar system. Currently we still have about 6 POTS lines going in to the system but in the next week or so when we are sure...- gtenney
- Thread
- Replies: 3
- Forum: Nortel: Norstar systems
