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 Chriss Miller 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: goterps1
  • Content: Threads
  • Order by date
  1. goterps1

    Summarization

    I have 4000+ records in DBO_MASTER table for Fund 49. I'm trying to get a total value of the Fund with the following SQL. Can you help with what I'm missing. SELECT DBO_MASTER.FUND, Format((sum(DBO_MASTER.TOTSHRSISS)+sum(DBO_MASTER.TOTSHRSUISS))*DBO_PRICE.PRICE,"$#,###.00") as BALANCE FROM...
  2. goterps1

    Using VB to create a table

    I have little experience with VB but I thought I could use a vb script to solve my problem. The outcome I want is to have a script that will run down each row in table A and compare rows to table B. Then print out or create a table with the rows from each table that do not match. (ex. start...
  3. goterps1

    Need help with unmatching query

    I'm using the unmatching query wizard to find records on table [Fund 49] that do not match records on table [Fund 83]. But I'm not getting the expected results. I'm trying to pull the records from the [Fund 49] table that do match either of the criteria in the FROM clause on the [Fund 83]...
  4. goterps1

    Missing Operator Syntax Error

    I'm getting a missing operator syntax error when executing the following query. Do I need additional parenthesis or operators when using more then one left join? SELECT DBO_MASTER.FUND, DBO_MASTER.ACCOUNT, DBO_MASTER.SSN, DBO_MASTER.FIDUCIARY, DBO_MASTER.REGLINE1, DBO_MASTER.REGLINE2...
  5. goterps1

    Missing Operator Syntax Error

    I'm getting a missing operator syntax error when executing the following query. Do I need additional parenthesis or operators when using more then one left join? SELECT DBO_MASTER.FUND, DBO_MASTER.ACCOUNT, DBO_MASTER.SSN, DBO_MASTER.FIDUCIARY, DBO_MASTER.REGLINE1, DBO_MASTER.REGLINE2...
  6. goterps1

    SQL <> statement

    Now I'm trying to pull all records from Fund 49 that do not match with Fund 83 based on SSN. Below is the SQL that I'am trying in I'm not retrieving any records. I know I should be retrieving records. SELECT DISTINCT [Fund 49].SSN, [Fund 49].FUND, [Fund 49].ACCOUNT, [Fund 49].OPENCLOSE FROM...
  7. goterps1

    SQL Count(Distinct.....)

    I'm recieving a missing operator error on the select statment when attempting to run the following sql. Can you help? SELECT COUNT(DISTINCT [Fund 49].SSN) AS Expr1 INTO [Matching 49] FROM [Fund 49], [Fund 83] WHERE ((([Fund 49].SSN)=[Fund 83].SSN));
  8. goterps1

    Select Count (Distinct....)

    I'm recieving a missing operator error on the select statment when attempting to run the following sql. Can you help? SELECT COUNT(DISTINCT [Fund 49].SSN) AS Expr1 INTO [Matching 49] FROM [Fund 49], [Fund 83] WHERE ((([Fund 49].SSN)=[Fund 83].SSN));

Part and Inventory Search

Back
Top