Search results for query: *

RiverGuy, I got results coming in now, but the VAR_Levels Field is only in the GLNAMES Table. This is the field I want listed, so when I Qualify it with GLNAMES.VAR_Levels, I am getting Nothing loading for this field and there should be tons of data in this field in the GLNAMES Table. AlleyCat1

RiverGuy, That SQL Exception goes Away but I get another SQL Exception on the Oda.Fill(oTable() Colored in YELLOW when I make the change. Ambiguous column name 'OBJ_ID'. Ambiguous column name 'ACCT_UNIT'. Ambiguous column name 'VAR_LEVELS'. AlleyCat1

I am trying to pull data from two tables that have Primary Key Fields COMPANY. I have tried to write the SQL AS: Dim sSQL As String = "SELECT COMPANY, FISCAL_YEAR, ACCT_PERIOD, CONTROL_GROUP, LINE_NBR, POSTING_DATE, OBJ_ID, STATUS, ACCT_UNIT, ACCOUNT, TRAN_AMOUNT, ACCT_AMOUNT, VAR_LEVELS...

I am trying to Inner Join Two Tables in a DataBase that I have made an SQL Connection To. I am trying to pull data some extra data fields by Company. The GLTRANS and GLNAMES Tables both contain Primary Keys on the Field COMPANY. I am pulling data into an Array so that I can reference each...

I am a technical user trying to remove a hyphen from a number. The Number -125987.50 should be 125987.50. Instead of -125987.50 I want to remove the hyphen before is assigned to another textbox field. Does VB have a function to do this? AlleyCat1