Do you know how to link a Sage 300 CRE report with a Microsoft Access table that indexes states and cities to counties? I have a need to print revenue by State, County and City. Because I can’t find where Sage 300 CRE has a table that indexes states and cities to counties, I use Microsoft Access to report Revenue by State, County and City using Sage 300 CRE records from BL – Invoice, BL – Item and JC – Job along with the Microsoft Access Table I created named “Cities, Counties and State”.
Sage Construction & Real Estate
Welcome to the Sage Construction and Real Estate products Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Sage 300 CRE General Discussion
Revenue by State, County and City
