Search results

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

Ok wow I'm dumb haha So the parameter input box went away, but now all my Expr1 = #error?? Can I do a Join if the table sizes are different? the lookup table is like 70 items long, where the 05 GL table is like 5000 items long. (I'm going to bring in more fields after, right now I'm just...

Query brings in 3 fields from table [05 GL] [G/L Account No#] [Description] [Phase Code] My lookup table [07 GL Lookup] [Input GL Account] [Input Description] [Input Phase Code] [PL4] To determine the PL4, I have to match up the 3 items... So I'm using the Dlookup in...

Expr1: DLookUp("[PL4]","[07 GL Lookup]","[G/L Account No#] = " & [Input GL Account] & " And [Description] = ' " & [Input Description] & " ' And [Phase Code] = ' " & [Input Phase Code] & " ' ")I have three columns I'm pulling off a table G/L Account No# Description Phase Code I want to do a...

Ok ok I think I found a way to solve this issue. If I run a Crosstab Query, Putting Company as my Rows, and Period as my header. I can run a simple query of that one to calculate the difference between two periods. Is there a way to set the criteria for the period in the Crosstab query...

I guess, this isn't a case in storing "calculated values." It's more of a case of I need to calculated values so I can store the data :banghead: lol. I have to calculate the monthly values using two YTD values every month to store into the database. I was hoping just to store the huge...