Search results

Is there a reason the Macro>VBA does not work in a working VBA? The entire line, starting with the DoCmd is red "out" It will not run as is.

Have access 2016. There is a button that converts macros into VBA resulting in various forms of the DOcmd. Seems simple but finding that my Access 2016 does not recognize the DoCmd. Is there something I need to fiddle with in Options or somewhere to make this work?

Have done some experimenting on your subquery solution. Surely it has merit, but think that I need more handholding or experience with SQL to make this work. Will continue to work this method but it's slow. Hopefully there is another, more simple solution out there. Thanaks

Wow. That's a new one for me! - Subqueries.. Never heard of that. Will have to study the URL hard. So I imagine, do this subquery thing, then link the subquery back to a form to display totals for each [ConsolidatedJob#] ? If there are easier ways, let me know. Many thanks!

I have a problem that is simple in Excel, but I am stumped how to do it in access. Here is the table in simplified form: [JobID] [ConsolJob#] [Job#] [FYr] [Month] [Customer] [TotalREvenue] [TotalCost] [GrossProfit] 1 2 [ABC1] [1234] [Fy17] [Feb] [Customer1]...