Thanks all.

I'm quite new to Excel, but I'm pretty familiar with Access and vba fo
Access

In Excel where can I add the code for function.

Thank

--
xca
-----------------------------------------------------------------------
xcao's Profile: http://www.excelforum.com/member.php...fo&userid=1453
View this thread: http://www.excelforum.com/showthread.php?threadid=26322

Menu -- Tools - Macro - VB Editor

I hope that helps! Good luck, I have been working on the
same transition for the last few weeks. It's not to bad,
but there are a number of differences.

Kevin
-----Original Message-----

Thanks all.

I'm quite new to Excel, but I'm pretty familiar with
Access and vba for
Access

In Excel where can I add the code for function.

Thanks


--
xcao
----------------------------------------------------------
--------------
xcao's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=14538
View this thread:
http://www.excelforum.com/showthread...hreadid=263222

.

xcao wrote ...

Thanks all.

I'm quite new to Excel, but I'm pretty familiar with Access and vba for
Access

In which case, you can do the CASE statement in the sql e.g.

SELECT
MyIntCol,
IIF(MyIntCol=4,'daily','')
& IIF(MyIntCol=8,'weekly','')
& IIF(MyIntCol=16,'monthly','')
AS frequency_text
FROM
MyTable
;

Alternatively,

SELECT
MyIntCol,
CHOOSE(yIntCol,
'','','','daily',
'','','','weekly',
'','','','',
'','','','monthly')
AS frequency_text
FROM
MyTable
;

Jamie.

--

.... or even:

SELECT
MyIntCol,
SWITCH(
MyIntCol=4,'daily',
MyIntCol=8,'weekly',
MyIntCol=16,'monthly')
AS frequency_test
FROM
MyTable
;

Jamie.

--