This content has been marked as final. Show 2 replies
Year(OrderDate) as Year,
Month(OrderDate) as Month,
Week(OrderDate) as Week,
Day(OrderDate) as Day,
'Q' & Ceil((Month(Addmonths(OrderDate,-3))/3)) as Quarter,
(UnitPrice*Quantity) as GrossRevenue,
((UnitPrice*Quantity) - ((UnitPrice*Quantity)*Discount)) as NetRevenue,
SQL SELECT *
FROM `D:\Test\Session 01\Data Sources\Nwind.mdb`.Invoices;
This table is taken from the popularly available NorthWind.mdb data source.
When i try to load these kind of fields. It giives me an error.