File: D:/MariaDB Data/groundscrewcen/report_criteria.MYD
q� STARTCODEStart Product Code ComboBoxSQL5 SELECT ProductCode FROM products ORDER BY ProductCodeK�� m� ENDCODEEnd Product Code ComboBoxSQL5 SELECT ProductCode FROM products ORDER BY ProductCodeK� � � MONTH
Month ComboBoxSQLq SELECT DATE_FORMAT(DateTimeOrdered, "%M %Y") AS Month
FROM orders
GROUP BY Month
ORDER BY DateTimeOrdered DESCN��r ;� TYPETypeOrdersComboBox Orders
RefundsN�� �� SORTBYSort BySupplierName, ProductCodeComboBoxN WeeksStock1
WeeksStock3
WeeksStock6
WeeksStock12
SupplierName, ProductCodeO5W� k � SORTBY Sort By AveMarkupComboBox3 AveMarkup
GrossProfit
CostOfSales
Sales
QtySoldQ9 � 1 � STARTDATE
Start DateYEARAGODateQ9 � 3� ENDDATE
End Date YESTERDAYDateQ9 � B �
VAT VATExcludedComboBox Excluded
IncludedQ9^4 5�
STARTDATE
Start DateYEARAGODateQ@ߠ 3�
ENDDATE End Date YESTERDAYDateQ@߯ B �
VAT( VATExcludedComboBox Excluded
IncludedQ@�� � �
SORTBY Sort By ProductCodeComboBoxc ProductCode
ROR DESC
AveMarkup DESC
GrossProfit DESC
Sales DESC
CostOfSales DESC
QtySold DESCQA � L �
WEEKSSTOCKALERT2 !Weeks Stock (for low stock alert)2TextQC?� 1 � STARTDATE
Start DateYEARAGODateQ]�I + � ENDDATEEnd DateTODAYDateQ]�W 6 � STARTDATE
Start Date STARTOFMONTHDateQ�< 0 � ENDDATEEnd Date
ENDOFMONTHDateQ�R r� PCNAMEPC Name ComboBoxSQLD SELECT PCName FROM audit
WHERE LogOn >= 20130101
GROUP BY PCName
Q�� 5 �# STARTDATE
Start Date STARTOFYEARDateQ�< / �$ ENDDATEEnd Date ENDOFYEARDateQ�R 5 �% STARTDATE
Start Date STARTOFYEARDateW��� / �& ENDDATEEnd Date ENDOFYEARDateW�� 5 �' STARTDATE
Start Date STARTOFYEARDateW��� / �( ENDDATEEnd Date ENDOFYEARDateW�� - �)
PICKLISTID Pick List ID TextXց 1 �* STARTORDERNOStart Order No TextW��� - �+
ENDORDERNO End Order No TextW�� 5 �. STARTDATE
Start Date STARTOFYEARDateW��� / �/ ENDDATEEnd Date ENDOFYEARDateW�� 7 � PURCHASEORDERNOPurchase Order No TextS2� 5 �0 STARTDATE
Start Date STARTOFYEARDateW��� / �1 ENDDATEEnd Date ENDOFYEARDateW�� + �2 ORDERNOOrder No11338Text`I� 5 �3 STARTDATE
Start Date STARTOFYEARDateW��� / �4 ENDDATEEnd Date ENDOFYEARDateW�� 5 �5 STARTDATE
Start Date STARTOFYEARDateW��� / �6 ENDDATEEnd Date ENDOFYEARDateW�� 5 �9 " STARTDATE
Start Date STARTOFYEARDateW��� / �: " ENDDATEEnd Date ENDOFYEARDateW�� 3 �; " MINIMUMSPEND
Minimum Spend100Textc�� 5 �< # STARTDATE
Start Date STARTOFYEARDateW��� / �= # ENDDATEEnd Date ENDOFYEARDateW�� � + ��? # GROUPBYGroup By EmailAddressC iomboBox[ EmailAddress
CustomerID
FirstName, Surname, CompanyName, Postcode
AddressLine1, Postcodede�� 6 �@ $ STARTDATE
Start Date STARTOFMONTHDated��� + �A $ ENDDATEEnd DateTODAYDated���