Left 2 digits in query

[rkrause]

I am trying to use LEFT in a query. But im not getting it to work.

right now in my query i have:

LOT2: LEFT(orders.lot,2)
Any help would be great.

 

[namliam]

LOT2: LEFT(orders.lot,2)
or
LOT2: LEFT(orders.lot;2)

Depending on your regional settings (comma could be a decimal sign, in which case you use the ; seperator)
If you have a table "Orders" that has a column "lot" it should work

 

[gemma-the-husky]

if it is entered correctly, the query editor should put [] round each bit

so it should end up looking like

[orders].[lot]

 

[boblarson]

And if lot is not in another table in the current query, you just need to use:

LOT2: LEFT([lot],2)