That worked! But now I want to do another one in the same line, so for instance now I want to add that if its dav* show "david"
how do you combine multiple iif's
Hi,
I have a table that has one column with values like bob 1, bob 2, bob 3 etc.
I want to make a query and for anything that is bo* I want it to just display "bob"
I put iff([column]=bo*,"bob") but that did not work. What did I do wrong.
Hello. I've always used access by myself and consumers. Now I need to work with an additional access programer. The problem I am running into is how to document what we are doing and what things mean.
Does anyone know a good website that gives examples on how to work in a group with access so...
The quote included the 60/12, a shoretel t1, 20 phones, ext and mailbox for them, personal call managers for all of them.
If we talk in general terms the average of the 3 different types of phones they have is about 300 dollars. Then you add 200 for a mailbox and extension, 125 for personal...
I have a price quote for a 60/12 and 20 phones. Just the hardware w/ licenses is 23,000. Then they are charging what I feel is to much for installation and training.
I'm willing to negotiate but I don't want to start at an outrageous price. For instance VOIP comparies phone systems for SMB and...
Hi. We have been looking at Shoretel for our small office. A friend suggested this system, which I had never heard of before and don't see many reviews of only. Has anyone compared these two systems?
We are looking for a call recording system to use with Shoretel. We need all incoming and outgoing calls on 5 lines recorded. We would like to have more lines added that are just sporadicly recorded but if the cost is to high we would give that feature up.
Type in Shoretel price list into google and you get a price list. The quote I just received from our vendor was way over those prices. Are those wholesale prices and I should expect a mark up, or are those retail prices and I should expect those prices.
Let me expalin the query. Its basically data with 6 yes no boxs for each letter. SO for instance it would be
Name | Address | yesnoletter1 | yesnoletter2 | yesnoletter3
So report1 looks for any person with the yesnoletter1 box clicked to yes. So if 10 people are in the system and 2 are clicked...
Hello,
I have an access database in access 2000. I have a variety of letters(reports) that are run in it. Here is my set up:
A command button on a form linked to a macro
The macro opens 6 reports(the letters)
There is a filter in the report that says yesnoboxinquery=True
What happens is the...
Hi VonZipper.
Can you explain how the auto attendant box would work in the shoretel system and why you feel it would be able to replace a mailbox in my example?
Thanks.
Hello. Sorry I wasn't clear. Basically as ron romano said Avaya says when you purchase Voice Mail Pro for a one time fee you can set up as many mailbox's as you want for no extra price. Is this incorrect? What do you mean by ports?
So lets say we have 20 phones, but we actually want 50...
We are considering Avaya IP Office and Shoretel. I am concerned about the licensing system of Shoretel. Everything needs a license. The vice president wants to be a supervisor you have to get a license. Want to also include someone else as a supervisor, you have to buy another license. And there...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.