Search results

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

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

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

Hi all, I need a simple query or queries that will do the following. First summarize the data by company name (Easy Part) then calculate the monthly value from 2 year to date values (Date field is text). I am going to append this list to another table to give me a monthly calculation by...