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!

  • Congratulations John Tel 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: jrball
  • Content: Threads
  • Order by date
  1. jrball

    Two Tables into one result

    I have two tables I am trying to get into one query, but I can't figure out how to do it. What I need is a final result with all 4 of the answer fields on the same line as the each one of the question fields. Table 1 - Answers Answer_ID Question_ID Answer_Text Correct 1 1...
  2. jrball

    Adding two NumberVars Crystal 10

    I have a CR 10 report where I have created two NumberVars and need to add them together and can't figure out the code to do it. Here's what I have so far: First NumberVar Formula Q1 - WhilePrintingRecords; If {GetSurveyReportValues;1.QuestionId} = 970 then Shared NumberVar SE1 := Sum...
  3. jrball

    SQL Query Help (Two Tables)

    I have two tables that I need to get data from Objects: PubID ModuleID Name CreatedDate 123456 620 Briefs 2/21/2007 2/21/2007 123455 620 Briefs 2/20/2007 2/20/2007 123454 620 Briefs 2/19/2007...
  4. jrball

    LIKE query - using a formatted string in ASP.net web application

    I have been struggling with this for a while trying to format the strselect string properly to execute the select command on an access database using a asp.net web application. I can't get it formatted the right way to bind the datagrid. Here is what I started with: condb = New...
  5. jrball

    Insert Muliple Rows from ASP.NET VB aspx form

    I am stuck. I have some vars being passed to an aspx page though a post method, and I am reading them through the request.form("varname") for each. I need to dump into a db table in multiple rows, how do I do it? I am going into a SQL database using VS.Net 2003. I was hoping to do a bulk insert...
  6. jrball

    Convert String 1:45 to seconds

    I have a colum in an SQL db that is the total time that it takes someone to complete an online assessment, but it's stored as a string. An example would be 1:45. So it took them one minute forty five seconds to complete the test. How do I convert that to a number first then to total seconds...
  7. jrball

    Passing parameters to sub report

    Crystal 10 MS SQL DB I have a report that has a main report and a sub report, that shows survey responses. I have four db tables I am using. One has questions, one has answers, one has voter information, and the last has voter answers. The way that I am having to report is the main report has...

Part and Inventory Search

Back
Top