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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |