Search results for query: *

Cheers for the reply. Sorry for my late reply, been busy writing documentation (eyes are bleeding!) Given you a star for info and quick response. Last question - Do you know off the top of your head if the TIME_STAMP logs when the line was written to Aspect (i.e. the end of the event) or when...

Hi Can anyone post me a few example lines of idle events from the AAC_EVENT table please (obviously omitting any personal/company info). I'm writing some code to pull thru idle time from the AAC_EVENT table and link with the CALLDETAIL table but the idle events aren't logging at the moment...

Hi Any server variables relating to user info (Auth_User, Remote_User, Unmapped_Remote_User, Logon_User) are not being picked up in IIS. This problem occurs on my laptop as well as remote (LAN) web servers. I'm running IE6 (IE6.0.2800.1106.xpsp2.030422-1633 with Q837009, Q832894, 3282...

Toby Try the following... SELECT * FROM tblToSearch WHERE Format(theDateField,"DD/MM/YY") = #14/07/03#;

Shellin' peas! Norris68, you're a star and thanks very much for a quick and easy to use response (CTRL+C, ALT+TAB, CTRL+V). Works like a charm... Andy

Hi I'm trying to create a query which gives an output something like... ScoreDist Tot %age 1. >= 85% 303 49.11 2. 75% - 85% 187 30.31 3. 50% - 75% 110 17.83 4. < 50% 17 2.75 Total assessments 617 I've got the Score distribution and Total columns...

daniel tried it, works like a charm. cheers for your help andy

cheers for the quick reply daniel forgot to mention the &quot;spanner in the works&quot; which is that i only want data from the QMS table for a specific month. the Q table holds staff details, the QMS table holds assessment details. i want to list all staff with grade G2 or G3 and show if...

hi i have 2 tables, Q and QMS common field's are QMS.AgentCupid and Q.Cupid i want to list all records in QMS and also the OverallScore field in Q if there is one. fields to view QMS.Name , Q.OverallScore sample output would look something similar to... Name OverallScore J B 75% A...

thanks michael how ridiculously easy the answer was! red faced but happy. will try as there's no data in the 2nd table so nothing to mess up (yet!) Many thanks Andy

Hi Gillies You need to find the first space from the left of the address then select from the right hand side of street up to this position Give this a try. I tested on a dummy table & query and it seemed to work fine SELECT addressbook.*, FROM addressbook ORDER BY town, Right(street,Len...

Hi All I have 2 tables (TABLEA and TABLEB). One is populated with data and has a unique field TABLEA.QMref. The other will hold extra data but will also have the same unique field TABLEB.QMref. I want to insert a new record in TABLEB from a form frmDATA with several checkboxes (and a QMref...

hi kupz try looking at MS Knowledge base article Q292063 (how to create a custom rule using VBA) some or all of the following code should point you in the right direction (haven't tested so don't know how useful - might even get flamed for posting duff code!!) I think this code needs putting...