-1

enter image description here

Show the Sales, Profit and ShipDate fields (only) of any records from the month of January (any year) where Region and Province are both Ontario.

Improve this question
1
  • 2
    What datatype is ShipDate?
    – Philᵀᴹ
    Feb 28, 2020 at 19:58

2 Answers 2

Reset to default
1

....... AND Month(Shipdate) = 1

Improve this answer
0

Does your shipdate in invoice table contain a date or a month only. If it's a date then you need to define an expression (a new field in your query as expression Month (shipdate) and then put your WHERE criteria January in newly defined expression. Hope this helps.

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.