The expression you entered contains invalid syntax

0
votes

Sales: Sum([Order Details].Unit Price*[Order Details].Quantity)

When I tried to calculate this sum,I received the following error:

The expression you entered contains invalid syntax

1
ms-accessvba

1 Answers

1
votes

try this syntax: Sum([Order Details].[Unit Price]*[Order Details].Quantity)

the field name 'Unit Price' contains a space character and has to be enfolded with square brackets (like 'Order Details' already is) and thanks for the welcome Toby :)