Hi, I have recently upgraded to SCM 3.5.1.
Having a poke through it I noticed the 'More Reports' button on the Reports screen. Having selected it I then went to view the reports.
No matter what option I chose when I pressed 'Display' I was met with the following run-time error:
Normal
0
false
false
false
EN-GB
X-NONE
X-NONE
MicrosoftInternetExplorer4
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin-top:0cm;
mso-para-margin-right:0cm;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0cm;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"Times New Roman";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;}
Run-time error ‘-214217900 (80040e14)’:
Syntax error (missing operator) in query
expression ‘ReceiptDetails.ReceiptID = Receipts.ReceiptID INNER JOIN Products
ON ReceiptDetails.ProductID = Products.ProductID’.
After which the program closes itself.
Any suggestions?
I have also tried this with the 3.5.3beta and get the same response.
Thanks
Dave
Dave
Grantham Scout Shop
www.scoutshop.grantham-scouts.org.uk