CODEWITHSUNDEEP
sqlms-accessms-access-2003jet-sql
Abs
Abs

Reputation: 57916

JET SQL for Access 2003

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

Upvotes: 0

Views: 291

Answers (1)

Fionnuala
Fionnuala

Reputation: 91356

Try:

 Orders.[Shipped Date]

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

Upvotes: 1

Related Questions