Prev: Number Format in Chart Datasheet
Next: How can I merge all my emails in outlook
From: Dirk Goldgar on 11 Apr 2010 23:56
"David W. Fenton" <XXXusenet(a)dfenton.com.invalid> wrote in message
news:Xns9D56C83D6B0CEf99a49ed1d0c49c5bbb2(a)74.209.136.98...
> "Dirk Goldgar" <dg(a)NOdataSPAMgnostics.com.invalid> wrote in
> news:A4A64D88-F016-4536-9420-03AA8C4D09E5(a)microsoft.com:
>
>> Split([Email], "@")(1)
>
> Split() works in code, but not in a query.


True, though I don't believe the OP specified that the expression needed to
work in a query.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

From: David W. Fenton on 12 Apr 2010 14:30
"Dirk Goldgar" <dg(a)NOdataSPAMgnostics.com.invalid> wrote in
news:FA350611-BB26-4430-8F3E-68F74B893B23(a)microsoft.com:

> "David W. Fenton" <XXXusenet(a)dfenton.com.invalid> wrote in message
> news:Xns9D56C83D6B0CEf99a49ed1d0c49c5bbb2(a)74.209.136.98...
>> "Dirk Goldgar" <dg(a)NOdataSPAMgnostics.com.invalid> wrote in
>> news:A4A64D88-F016-4536-9420-03AA8C4D09E5(a)microsoft.com:
>>
>>> Split([Email], "@")(1)
>>
>> Split() works in code, but not in a query.
>
> True, though I don't believe the OP specified that the expression
> needed to work in a query.

No, but I think an answer to a question that's not specific needs to
account for both possibilities.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
From: Dirk Goldgar on 12 Apr 2010 14:57
"David W. Fenton" <XXXusenet(a)dfenton.com.invalid> wrote in message
news:Xns9D5893954B3FFf99a49ed1d0c49c5bbb2(a)74.209.136.82...
> "Dirk Goldgar" <dg(a)NOdataSPAMgnostics.com.invalid> wrote in
> news:FA350611-BB26-4430-8F3E-68F74B893B23(a)microsoft.com:
>
>> "David W. Fenton" <XXXusenet(a)dfenton.com.invalid> wrote in message
>> news:Xns9D56C83D6B0CEf99a49ed1d0c49c5bbb2(a)74.209.136.98...
>>> "Dirk Goldgar" <dg(a)NOdataSPAMgnostics.com.invalid> wrote in
>>> news:A4A64D88-F016-4536-9420-03AA8C4D09E5(a)microsoft.com:
>>>
>>>> Split([Email], "@")(1)
>>>
>>> Split() works in code, but not in a query.
>>
>> True, though I don't believe the OP specified that the expression
>> needed to work in a query.
>
> No, but I think an answer to a question that's not specific needs to
> account for both possibilities.


Quite right. My first post was just to show a couple of other ways to skin
this cat (poor critter!), but it would have been better if I'd thought of
the query issue.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

First  |  Prev  | 
Pages: 1 2
Prev: Number Format in Chart Datasheet
Next: How can I merge all my emails in outlook