thankQ Help
Views have been created which are already joined thankQ tables. thankQ Tables can also be selected as well as some Lookup tables.
1.Click New Report
2.Click Run Query Builder
3.Scroll down the Query Builder to locate the Table or View required for the report
View_BatchDetailContactAndArchive is a view of all payments of every contact whether they are in the archive or not along with their address information
When you click on a table the fields relating to this table are display at the bottom left of the screen. This also displays what type of field this is e.g. Date, Decimal, String. Int32 etc.
4.Double click or drag to the Name window
5.Place a tick in each required field
Serial Number Date of Payment Payment Type Payment Amount Destination Code |
Source Code Sort Code (BSB No.) Cheque Number First Name Key Name |
This will place the fields in the bottom window and build the query on the right
