By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,222 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,222 IT Pros & Developers. It's quick & easy.

Query Expression to Return a Part of a Field

P: n/a
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!
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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
*******************************
Nov 12 '05 #2

P: n/a
"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.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.