Recent content by angeltink99

Okay, so I ran the following portion of the code with breaks at each of the emoticons below: :mad:Set dbs = CurrentDb DtImportTBL_CD_ATT_DATA = Date$ :mad:strsql = "SELECT [TBL_CD_AT&T_DATA_ADJ].*, [TBL_CD_AT&T_DATA_ADJ].[Billing Number] FROM [TBL_CD_AT&T_DATA_ADJ] LEFT JOIN ETSBLOG ON...

After all my reading yesterday, I figured as much. But I can't find the difference in the data anywhere. I looked at the design of the raw data table and compared it to the last table referenced in the code, which is where the data gets dumped into. All the data field types look consistent, all...

I have a monster of a database at work and needed to adjust a bit of the program language. I am now getting a run-time error, but only some of the time!! To premise this, the code is all part of a process where we import data off a 3rd party disc, format it through access to what we need per...

Okay, never mind. A union query solved this portion of my problem. I now have all the data in one query in the right columns with all the duplicates. Now I am off to try the query from the reply by plog in order to pull it all together and simplify with totals. I will be back to report on my...

I think this will get me close to what I expect, however, the original table is not arranged correctly off the bat for me to go straight into this combining query. The original table does not have the LD Charge column in it at all. I created the column using all the BB charge types. In the...

I have a table that has dulicate account numbers but unique charges for each row. I need to combine them into one new table without the duplicates but with the unique data in tact. The fields are: Invoice # Charge Type Monthly Charge Tax Charge Usage Charge The charge type is either AA or BB...