I'm new to this and am looking for a bit of guidance, I am using Sage Act V18 - Using Microsoft SQL Server\MSSQL10_50.
I have a couple of fields within the database that are either true or false.
I want to be able to run a query from a report builder that says:
Between this date and that date:
There were this many new records created:
During this period this many Field1 = TRUE
Then repeat this for Field2 = TRUE
Then to present that in a report.
Can anyone suggest a script for this?
All fields are in main contact database.