Search results for query: *

Your so right ... All I have to do is COUNT the 'service' field with the Pass or faild critiria and group them together ... IM AN IDIOT AND MADE MYSELF A PROBLEM. TAXI !!! Any many thanks for helping this fool out - some time one cannot see for looking !

Hi... Im not sure what you mean dhookom - I think its all already there in the table structure. They are already grouped by addressbook.Service='RN' The query joins 3 tables 1.tbl.addresssbook (stores the name of the person and their rank) 2.tbl.applications (the PersonID field from...

Thats just and example, ive removed that line from the WHERE clause .... :-) So infact it reads thus WHERE addressbook.Service='RN' AND(Applications.StatusCode='Passed' OR Applications.StatusCode='Failed') AND courselist.CourseTitle=coursename AND courselist.EndDate BETWEEN enddate1 AND...

Cheers r937 Can I add that to my other critiria .. i.e. WHERE addressbook.Service='RN' AND addressbook.ServiceLevel='Officer' AND(Applications.StatusCode='Passed' OR Applications.StatusCode='Failed') AND courselist.CourseTitle=coursename AND courselist.EndDate BETWEEN enddate1 AND enddate2...

Hi ... OK,I think ??? I think I want to add up (COUNT) all of the entries for 'Officer' and 'Snr Ranks' and have a total of all of them together. So I guess Ill have to count all the entries for each of the variables 'officer' = 12 (COUNT) + 'Snr Ranks'=4 (count) so the total would be 16 ...

As a beginer,Im trying to SUM values in a single field where they meet the critria below. The field is wish to SUM is "SERVICELEVEL" I wish to SUM the following addressbook.ServiceLevel='Officer' + addressbook.ServiceLevel='Senior Ranks' + addressbook.ServiceLevel='Junior Ranks' = x The...

Hi .Im using ASP. Authentication is via a table in Access running on our Intranet server (W2003-R2). Ive simply used the server behaviour bulit into - WHOOPS IM ACTUALLY USING DW CS3 !!!! It just jumps me straight back to the 'tryagain.asp' when I use the correct username and password. Its got...

Hi ... firstly ive searched through the previous issues of a similar nature with no luck ... Im using DW 8, MS Access running on WIN2003 R2 and IIS6. Ive simly used the built-in server behaviour and tp log in user, it just doesnt work. Im getting the user levels from the access database which...

Hey PaulBricker your a genius !!! Finshed up with this and it works great - It always looks simple when somebody else does it for you ... Many thanks Matey ;-) Final code <% Dim xBoat,svcElapsed xBoat = b_status("name") & "" svcElapsed= DateDiff("d", b_status("scv2_ann"), Date()) If...

Hi .. thanks for the code. It only returns the image 'on.gif' in all date situations. I have put dummy data to emulate the required date conditions. The 'IsNull' is working though. Ive had to put a 'x' in front of Elasped as the are more than one of these on the page. Ive palyed around a bit but...

Hi ... The following code warns me via an image that a date is greater than a year old. It works great but im looking to put a third image warning that the "safety_insp" date field in MSAccess is greater than '335' days old displaying the image file 'amber.gif' Also at the same time if the...

WINDOWS SERVER 2003 R2, STAND ALONE - NO AD Hi ... Ive just installed Sharepoint and trying to setup new top level web site but it does not like any user accounts that I try to use. I get user does not exist or user/group <> is unknown. There is only 1 domain on this standalone box . Any...

My first go at .NET .. Im building a datagrid to display fields in a database. One of the columsneeds to have this code running in it - not sure how to do it. The script works fine in classic ASP. Example:Cut out from main script <asp:TemplateColumn HeaderText="Warning"...

Hi -- using the /24 I get about 12 or 15 decimal places !!!

Thanks Sheco - Im not sure its working .. Im using the following code, but when i run it all the boats have a check.jpg when infact they are over 24 hours old, the one record that is less than 24 hours still displays the check.jpg ??? <% Dim strBoat, iElapsed Do While Not rsBoats.EoF strBoat...

Hi Sheco .. works great, made a couple of changes thus .. <%Dim strBoat, iElapsed Do While Not rsBoats.EoF strBoat = rsBoats("HMSTC") & "" iElapsed= DateDiff("h", rsBoats("PositionDate"), now()) Response.Write "HMSTC- "& strBoat & " &nbsp; " Response.Write "Hourse Since Late...

Thanks Sheco - thats really helpful - ill carry on working/understandng. ... You guys online really make a difference, this has helped so much. ill get when its working. MANY THANKS :-)

SO ... <% SELECT DateDiff("d",[BoatPosition.PositionDate],[BoatPosition.EnterDate]) AS LastDate FROM Boats INNER JOIN BoatPosition ON Boats.HMSTC = BoatPosition.BoatName %> ?

Okkkaaayyy .. being a beginer, thats a bit of a mountain, could you point me in the right direction :-)

Got the following query, works great in MS Access, put it into my ASP page and returns .. Too many paremeters Expected 1' Checked all the spelling and fields - all ok, It works in MS Acess as a query Query .... SELECT DateDiff("d",[BoatPosition.PositionDate],[BoatPosition.EnterDate]) AS...