Recent content by BustyAshley

The table names are Master Table Table1 Table2 Table3 Table4 Table5 Table6 All the tables have a column named "Contract" I need to set rs = Master table with column "Contract" filtered by Me.cbBox

All 6 tables have different columns, and different structures. The only thing that brings the 6 of them together is "Contract". Each Table has a Column Labeled "Contract". The master table just slams these tables together like; Contract A / Table 2 / $5 Contract A / Table 3 / $6

This worked. I didn't need the 'nz' part of the look up because every record contained a contract ID. Thx

I'm currently using the Code below to export a table from Access into a new workbook in excel. Is there a way to modify this code to do a couple things; Part A: I want to put a cbBox on my form tab that has a contract (First Column on master table), then use that as an "activate filter"...

FROM [Total Billables Table] LEFT JOIN [10 Account Mappings] ON (nz([Total Billables Table].[Contract #],"")) = nz([10 Account Mappings].[SiteID],""); I'm using the above to do a lookup but I realized my [Contract #] has 10 characters vs my [siteID] only having 9. Example would be [Contract...

AKA off the asset number I wanted columns MFR, System Descrip & Model, from my lookup which all are determined based on the asset number

lol turns out, this was the SQL statement I wanted :/... I needed the NZ because I have blank ASSETNum's but I only needed 1 from statement because the three columns I wanted to add, could all be grabbed from that. SELECT DISTINCTROW [06 Rev Rec].ContractID, [06 Rev Rec].AssetNum, [06 Rev...

Query keeps saying JOIN Expression not supported... I can't figure out why? (It works independently for each one, but not when I put the three togethers SELECT DISTINCTROW [06 Rev Rec].ContractID, [06 Rev Rec].AssetNum, [06 Rev Rec].FeatureNum, [06 Rev Rec].Period, [06 Rev Rec].Revenue, [06...

ughh... turns out when I open a query, it auto opens to the last saved query view. So I have to get into the practice of going to SQL View prior to closing and saving any query

Quick question.. Every time I open the query, it only allows me to open it in "Design View." Once I open it in design view and hit ok to the erros, I then can go to SQL View but the code gets modified, so I have to repaste in the code you wrote for it to work correctly. Is there any way to...

OMG!! Thank you soooo much

I guess the Join or the DLookUp isn't doing what I expected. My thought that is if it the phase code was blank in both (Table & Lookup) that the Dlookup or Join would still work. This use to be done in excel, we would combine the 3 columns and do a vlookup. So having blank in a column was fine...

I get all my rows now but I don't get the PL4 lookup for the items missing PL4

Ok I updated the Types.. I realized one was number and one was text... the output is working for anything with a Phase code, if it doesn't have a phase code, it doesn't work Edit: All items will always have a G/L Account No# & Description... only a select few will have a phase code...

I've uploaded a trimmed out example