Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jamiec1
  • Content: Threads
  • Order by date
  1. jamiec1

    how do i setup a sql2k server to allow user to connect via Ent manager

    need to allow remote access. thanks
  2. jamiec1

    error problems

    the error i keep getting is Server: Msg 306, Level 16, State 2, Line 1 The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. Not sure why it is throwing up error but a bit rusty on my sql code is SELECT [JobRecords].[JobID]...
  3. jamiec1

    wrong number of arguements

    I am getting this error when i run the following code SELECT ProblemCategory.ProblemCategory, IIf(IsNull(Count(JobRecords.JobID),0, Count(JobRecords.JobID) )) AS JobsInCat FROM CustomerContracts INNER JOIN (CoveredSites INNER JOIN (ProblemCategory right JOIN JobRecords ON...
  4. jamiec1

    possibly an impossible problem

    table months contains 01/01/2002 01/02/2002 01/03/2002 etc QRY: SELECT format(JobRecords.DateTimeCreated, "yyyy/mm") AS Mnth, count(JobRecords.DateTimeCreated) AS Tot FROM ProblemCategory INNER JOIN (CustomerContracts INNER JOIN (CoveredSites INNER JOIN JobRecords ON...
  5. jamiec1

    month report to include zeros

    I need to display the count of jobs logged by month but include zeros where no jobs have been logged in a mth SELECT format(DateTimeCreated, "yyyy/mm") As Mnth , count(JobRecords.DateTimeCreated) AS Tot FROM JobRecords GROUP BY format(DateTimeCreated, "yyyy/mm"); this...
  6. jamiec1

    working out the number of working hours between two date times

    this is a problem i have been trying to get my head arround but to no avail .. any help is appreciated. jamie
  7. jamiec1

    best or favorite open source sites ?

    just starting flash and would find helpfull thanks
  8. jamiec1

    How can i force access to see all dates as uk format

    It treats 01/02/2001 as the 2nd of jan which is a huge pain .. any way to force it to see all dates as being uk format .. my regional settings are set to uk so it cant be that. thanks
  9. jamiec1

    how do i work out the number of working hours between 2 dates+times

    this is the bain of my life at the moment and its driving me nuts. I found a formula to do it in xl but i cant get it in access. Its for a helpdesk project im working on so i need to know how many working hours a job has been open for. Any help would be really appreciated

Part and Inventory Search

Back
Top