Query Expression to Return a Part of a Field

[Yisroel Markov]

Greetings,

In Access 2000, I have a select query where I need to write an
expression that will look at a text field [Account] and return the
third character. (This will be used later in a report based on this
query to create subtotals.) In Excel I'd just use the Mid() function
-- =Mid([Account], 3,1) -- but this is a worksheet function and can't
be used in a query. Is there another way to accomplish this?

Thanks for reading!

[Rick Brandt]

"Yisroel Markov" <ey*******@iname.com> wrote in message
news:2f**************************@posting.google.c om...

Greetings,

In Access 2000, I have a select query where I need to write an
expression that will look at a text field [Account] and return the
third character. (This will be used later in a report based on this
query to create subtotals.) In Excel I'd just use the Mid() function
-- =Mid([Account], 3,1) -- but this is a worksheet function and can't
be used in a query. Is there another way to accomplish this?

Mid() absolutely does work in queries.

--
*******************************
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
*******************************

[Yisroel Markov]

"Rick Brandt" <ri*********@hotmail.com> wrote in message news:<bl************@ID-98015.news.uni-berlin.de>...

"Yisroel Markov" <ey*******@iname.com> wrote in message
news:2f**************************@posting.google.c om...

Greetings,

In Access 2000, I have a select query where I need to write an
expression that will look at a text field [Account] and return the
third character. (This will be used later in a report based on this
query to create subtotals.) In Excel I'd just use the Mid() function
-- =Mid([Account], 3,1) -- but this is a worksheet function and can't
be used in a query. Is there another way to accomplish this?

Mid() absolutely does work in queries.

You're right. Turns out that utility.mda wasn't referenced.