Search results for query: *

Yeah, I think you're right because it makes you put it that way. But any ideas as to why I keep getting the error about Person as an aggregate function? Can anybody see what's wrong with this?? Lon

Here is the query I'm trying to run, the whole things works when I take out all the sum and group by statements. When I run this one I get the "you tried to execute a query that does not include the specified expression "person" as part of an aggregate function." SELECT [Mission Log Table...

Thanks Leslie! Forgive me for my abundance of dumb questions but, does that mean that I should include the sum statements in both the SELECT and UNION SELECT portions of my query and then use the GROUP BY to protect them. Or just add them to one statement, or in their own statement???

Hey, Ginger's solution works great, but only without my sum statements. You can see them above. If I'm doing the Union Select, where do I plug in the sum functions so it doesn't try to aggregate those? I keep getting the: "you tried to execute a query that does not include the specified...

Thank you so much Ginger and PHV! slick = 'WORKS!' [shadeshappy]

OMG Ginger, I'm sorry everyone! what it should look like is this: |AWO/WD|AWO/WD Inst/Eval|Mission|Date |Jim | |1 |2/3 |Jim | |4 |2/7 | |Jim |2 |2/5 |Larry |...

Thanks PHV! Thats real close, but it seems to aggregate my position fields into one field. I need the names in one, but not the positions. Heres my sql without the union select: (The AWO/WD and AWO/WD Inst/Eval are the two job columns containing names) I need the query to search and organize...

I'm sorry, it seems to have lost the formatting. The table looks like this: Job#|Date|Supervisor|Lead| 1 |2/3 |Jim |Tom| 2 |2/5 |Tom |Jim | 3 |2/6 |Larry |Tom| 4 |2/7 |Jim |Tom| The report on personnel and their...

This is probably so easy, but the forum search was down sorry. I have a table organized by jobs, each record has info as to what person did the job and the position they served (which has several columns for different types). So I want to create a report that is organized by person and listing...

Is there a way to prevent an analog line from doing a progressive conference (hook-flash)?

As for Cawho's reply I also agree. Untill I find my magical answer, that is the only way to do it. The only flaw to the "in your chair" method is if you only have CDR running on your trunks or special interest TN's. Then all the interoffice traffic would not be accounted for. As for...

HA! I hope my "big talking" pays off. I'll shoot over to the phreakers forum and let the hackers figure it out. :)

Thank you all for taking the time to respond to my question. There is a way, and I will find it. Then I will let you know what it is. ;)

OK... no way what? This functionality is available on DMS systems as well as the tiny little 30 port PBX's I used in the military. But not on a half mil 81C?

My users connect to the MICB conference with analog lines via a console system. While on the conference, the users accidentally hook flash the line and get a second dial tone, they think that the original call to the MICB is disconnected so they call it again. This effectively connects the...

I need to know how to check analog ports for an actual phone set. I know you can do an IDU on the digitals. I searched and found some suggesting to use LD 30, but that seems to return an OK even if I go and intentionally unplug the phone myself. Thanks!

I have a search form that opens a recordset clone based on a selection. My problem is that my code uses find first. How can I open a second or third record when there are duplicate entries?