Recent content by reggiete

hello ridder, i am using SQL server and i get the 'Format' is not a recognized built in function.

Hello all, I am trying to format a varchar column which as dates in the format of '09152016'. I would like to convert the text date to 09/15/2016.

Hello All, I am just try create a temp table from excel VBA. Below is the code i have which works for a select statement. But i want to create a temp table. 'Initializes variables Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim ConnectionString As String Dim StrQuery As...

ok Plog. I create to temp tables. T1 has all the IDs with open ( Query 1 inserted into) and T2 has all the IDs with closed ( query 2 Inserted into) Now I want to join the two tables and give me a list of IDs from T1 where the ID was not found in T2 Create Table #T1 ( TicketHistoryID...

I have a select query that pull records based on certain where criteria. I want the recordIDs that are returned to be used in another query to see if the ID exists? For example Select Query 1 pulls all records with a open status. I want to have another query run taking the IDs found open in...

Im aware that the query is calling for the TOP 10 records by Analyst, so how can i have the query pull 10 records that are in the " Completed " status?

Hello All, I am needing some help on a query i am trying to build. I am needing to select 10 random records by each Assigned Analyst. See below code SELECT TblEmailReview.[Assigned Analyst], TblEmailReview.ManagerAssigned, TblEmailReview.[Testing Month], TblEmailReview.Status FROM...

Ahh i see my error. THanks Pbaldy !!!! simple and i was stressing over this all morning

sorry didnt post full code Sub EmailMemo() Dim FilePath As String Dim FileName As String Dim oOutlook As Outlook.Application Dim oEmailItem As MailItem Dim CompUser As String Dim Path As String Dim myDate As String Dim todayDate As String Dim rs As Recordset Dim customerEmail As String Dim...

Hello All, I have the below code in a module to call outlook. The problem i am having is the .To part. The outlook dialogue does pop up but all of the emails located in the Query1 do not show up in the To box in outlook. The .CC shows all the emails for the manager but .to box only shows 1...

Figured it out thanks everyone!

Hello All, Could someone help with the SQL query below. SELECT Tableau.*, "Pass" AS AccessVerification FROM (Tableau LEFT JOIN AAL_Matrix ON (Tableau.[Access] = AAL_Matrix.[PrimaryRole]) AND (Tableau.[AAL] = AAL_Matrix.[AAL])) INNER JOIN TblApprovedExceptions ON (Tableau.[Access] =...

Ah i finally got it to work thanks PLOG!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

SELECT Tableau, "Fail" AS AccessVerification, Tableau.Access AS CurrentAccessRights FROM Tableau LEFT JOIN AAL_Matrix ON (Tableau.[AAL] = AAL_Matrix.[AAL]) AND (Tableau.[Access] = AAL_Matrix.[PrimaryRole]) LEFT JOIN TblApprovedExceptions ON (Tableau.[EID] = TblApprovedExceptions.[EID]) AND...

Hello All, I am trying to Join the 2 Select Queries below and not sure on how to. What i would like the results to show is a Fail for any user who has unapproved access. The first Select statement checks the tbl named AAL_Matrix against the Tableau table and provides a "Fail" for anything...