JET SQL for Access 2003

Question

Hello all,

I have the following SQL statement:

Select Choose(1,Orders.Employee, Orders.Customer) as Name1, 
Choose(2,Orders.Employee, Orders.Customer) as Name2, [Shipped Date]
FROM Orders;

However, the field "[Shipped Date]" has a space in it and hence why I have put square brackets around it. The problem is, in SQL view, it seems to think that the sqaure brackets means its a parameter and its asks me for a value but I don't want a value, I want to be able to select that field name!

Thanks all for any help

Answer 1

Try:

 Orders.[Shipped Date]

As an aside, it seems a little odd to use Choose when the descision is already made.