|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 30th, 2006, 07:50 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MONTHNAME when getting external data from Access
I have a query in MS Access that uses the monthname function. When I try to
create a pivot table from external data (using the DB as the source) I get an error that the function isn't supported in Excel. Is there another function I could use? The function as it appears in Access is: monthname(month([DATE])) Thanks. 
|
|
#2
June 30th, 2006, 08:40 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MONTHNAME when getting external data from Access
You could use something like this:
=LOOKUP(MONTH(date),{1,2},{"January","February"}) Ensure that the #'s are in increasing order as you enter them. "-PJ" wrote: I have a query in MS Access that uses the monthname function. When I try to create a pivot table from external data (using the DB as the source) I get an error that the function isn't supported in Excel. Is there another function I could use? The function as it appears in Access is: monthname(month([DATE])) Thanks.
|
|
#3
June 30th, 2006, 08:50 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
MONTHNAME when getting external data from Access
Hi,
monthname(month([DATE])) could become a cell format as "mmmm" On Excel french version : =texte(date;"mmmm") expected to be =text(date,"mmmm") HTH FxM -PJ a écrit : I have a query in MS Access that uses the monthname function. When I try to create a pivot table from external data (using the DB as the source) I get an error that the function isn't supported in Excel. Is there another function I could use? The function as it appears in Access is: monthname(month([DATE])) Thanks.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Inserting a new line when external data changes | Rental Man | General Discussion | 0 | January 11th, 2006 07:05 PM |
| Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
| How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
| transpose | john | Using Forms | 1 | November 24th, 2004 06:16 PM |
| Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
Linear Mode
