Search results

Thank you! It works like a charm!

Hi, I am wondering If I can Sum the value of rows in one field of my Query Table and Inserting that Calculated value into the bottom of the summed Row in the VBA or through Query Design View. Please let me know, Thank YOU! Below I have attached the picture of the data that Im trying to sum and...

Hi, I have a problem deleting a specific row and field that my query have. What I want to do is mainly delete a specific rows in the my Query table that has : Field 1, Field 2, Field 3, Field4 what i tried to do was doing is create and array that loop through the Query table and check in field...

Nevermind I got it to work now.... Thanks for pointing em out! :D

I have added a , to fix the SessionHeader.ChamberNo," & _ "SessionHeader.GroupID (spacing problem) however, I do not know what to do with SessionData" & _ "INNER JOIN (spacing problem) Please show me how to space them....or better yet how to fix the problem I am having in detail...

Access only tells me "Run-Time error '3131'" "Syntax error in FROM clause" the statement inside the "" are given to me from SQLview option from query that I have already made using simple query Wizard from Microsoft access...I doubt there is anything wrong there.... im just confuse why I got a...

Hi! Im wondering why my code below Does not work!.... any suggestion??? strStatement = "SELECT SessionData.RunNumber, SessionData.SessionID, SessionData.SequenceNo, SessionData.SubjectID, SessionData.Latency, SessionData.BeamBrk1, SessionData.BeamBrk2, SessionData.BeamBrk3...

My ultimate goal here is to create a VB program that does what I did to get set up the Query for the table1 and Table2. Almost like macro that can do this routine without me clicking through Query Wizard or Setup to create a Query for Table1 and Table2 in my example. (I tried using macro but it...

pretty much what I am trying to accomplish here is to automatically create a query using: The SQLview i got is below: SELECT SessionData.RunNumber, SessionData.SessionID, SessionData.SequenceNo, SessionData.SubjectID, SessionData.Latency, SessionData.BeamBrk1, SessionData.BeamBrk2...

From SQL view statement and plugging it DoCmd.RunSQL Hi, My name is Vincent I'm very new to Microsoft access and what I want to do with microsoft access is to combine two table1 & table2. So what I did was that I created a query to combine the two tables and extract the datas from the two...