Search results

Works great thank you!

lol, glad you posted I'm always happy to read *when I have time* and try and learn :D so I have a question for you, when you say Do you mean you have your own custom ribbon made with drop down options? or are we talking about just the standard ribbon??

Hey mate, nevermind about the systray post - looking at it, unless you feel like playing around and working it out *for something to do* I've just finished my xml / custom ribbon and hidden the navigation bar and removed the privacy & opens from the "file" menu and have stopped hiding the...

LOL Hope we provided your day/nights entertainment ;) Just had a look at what you posted / my stupid attempt and the final result (SQL) can see what I was missing, all a learning curve... Did you ever get a chance to look at that SYStray one I uploaded for you? I think in the end I'm going to...

You were basically spot on mate (I'm sure you already knew that :D)

OMG :banghead::banghead::banghead::banghead::banghead::banghead: This was SOOOOOOOOOOOOOOO easy after you mentioned that last bit and I googled it and realized that access 2010 basically does it all for you! Its basically/is what VBAiNET said ages ago that I couldn't get to work properly with...

pretty much everything that is in that query.... So that the manager of this team jumps in runs the query and can see the custID that is coming back into the team, the agents that had assisted & their notes & date of the call. So if the table had another entry for custID 20 within the last 7...

Yeah I got what you were saying, mine was more of a question than anything... I'm hopeless trying to explain / ask things via text so it obviously came across wrong :) I'm not only really new to the forum but as you can see, VERRRRRRRRRRRY new to databases as well :( Everyone on this forum is...

Kind of the idea that I'm after... If you have a look at the OLD query now, it would be perfect if it did not show the record with customer ID 20 ** this is obviously showing the first call which is fine, I can handle that because it seems a little more difficult than I first thought to get...

exactly :) and if possible I wouldn't want to see the first call that came through - because that would be perfectly acceptable, just anything after that Now that you say it like that - explained so simple I feel retarded :D

so basically, a query that can be run @ any point during the month that will return all of the calls are in the 7 day period that are more than 1 call for the same custId

haha no worries :) the parameter query would be impossible as well, there is like 40 odd people in the desk that take roughly 500+ calls a day, from a base of roughly 10+ million customers so in the 7 day period you may have for example 1000 different customers, but 2+ calls for the same...

did you have teamviewer? http://www.teamviewer.com/en/download/windows.aspx and I can show you the actual live db

okay I think I get what your saying... I tried what VBAiNET mentioned SELECT Table1.Note, Table1.Agent, Table1.InterDate, Table1.CustID FROM Table1 WHERE InterDate BETWEEN Date() AND Date()-7 GROUP BY Table1.Note, Table1.Agent, Table1.InterDate, Table1.CustID HAVING Count([CustID]) > 1; but...

So there is 4 entries in the table 3 with 2000000000 & 1 with 20 basically what I'd like to see is: Record 1 & 2 because they are the same CUSTID within 7 days. record 4 shouldn't show because its greater than 7 days Record 3 shouldn't show because its not the same CUSTID So it should only...

I guess it didn't really matter in this instance how old it was since it was just to do with relationships and stuff not really code or features?

lol I wish you could IM on forums, so we don't want more calls (no matter who it comes from) for the same CUSTID. does that make sense? I hope so :) I'm hopeless at trying o explain stuff via text :P

This query is pretty close but it should not be showing the 3rd record because the customer ID is not >1

Sure.... So the DB itself if basically going to be used in a call centre to track calls coming through to a help desk... The first call that comes through is totally okay, any calls that come after that within the last 7 days are classed as a repeat call that should have been avoided.

okay think I've got it all in this copy for you left all the modules in there and the code for one of the forms when you click any of the 3 buttons up the top to change the forecolor / backcolor or font & color it just errors... I'm not sure what would be easier, if it is easier for...