Hi ,
Having finally sorted out my till and most other issues i have just been playing around with reports but under the more reports page i tried the 5yr chart of sales by month for category and i get the following error
Run-time error '-2147217900 (80040e14)':
Syntax error (missing operator) in query expression 'RecieptDetails.RecieptID = reciepts.RecieptID INNER JOIN Products ON RecieptDetails.ProductID = Products.ProductID'.
not that these reports are massivly important but they might be useful.
Cheers
Ben