Search results for query: *

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...

Unfortunately I have a where clause of 5 fields to compare. If 1 field out of the 5 do not match then I want to pull the row from both tables. If all 5 fields match then I want to skip and go to the next row.

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...

Nevermind... I just think I found my problem. Thanks again for your help.

I have a total of 2046 rows in [Fund 49]. I received a total of 2 records when I run a query to Match the records based on the same criteria. When I do the NON matching I'm only receiving 2039 records. So I'm missing 5 records. Basically, I want the NON matching to pull back every record...

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]...

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...

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...

I see where the confusion is with the FROM clause. I thought I had to join the two tables based on the SSN number. My select statement did work when I'm trying to find matching SSN ex. [Fund 49].SSN)=([Fund 83].[SSN]. So what I'm attempting to do now is find those SSN in Fund 49 that do not...

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...

Great it works! Thanks!

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));

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));