Thanks for getting me started. The following works if fist_pmt_effective is blank but otherwise I get an error:
1stPmtCat: IIf(Month([ReportDate])=12,IIf(Nz([first_pmt_effective],0)=0,"1st Pay N/A",IIf([AgeDays]<68,(Month([ReportDate])+1)-12 & "/1 and newer",Month([ReportDate]) & "/1 and...
This is how it looks in Excel, how do I need to change it for Access?
=IF(MONTH(A2)+1=13,IF(OR(ISBLANK(E2),E2=0),"1st Pay N/A",IF($C2<68,(MONTH(A2)+1)-12&"/1 and newer",MONTH(A2)&"/1 and older")),(IF(OR(ISBLANK(E2),E2=0),"1st Pay N/A",IF($C2<68,MONTH(A2)+1&"/1 and newer",MONTH(A2)&"/1 and...
Nope. I can pull up the datasheet view and right click to remove all blanks and it works. I can create a filter on the query and it works. I copied the criteria logic from the filter query and pasted it into my query and it doesn't work.
I have an Excel sheet where the date for field O83 is formatted General. In Access I want the query to only pull up the records where that field has data. I have tried:
Is Not Null
>01/01/2000
<>""
"*"
"/"
Like "*/*"
Nothing changes it. Unable to change format in Excel because the file is...
Is it possible to change a date format from:
yyyy-mm-dd 00:00:00 to mm/dd/yy
in a query? And also to have the today's date in the field if the field is empty?
The data is linked to an Excel file so I'm not able to make changes from within Access. So would that prevent the query from changing...
Currently I have:
IIF (ISNULL([first_pmt_effective]),"1st Pay N/A",IIF([Age Days]<68,Month(now())+1&"/1 and newer",Month(now())&"/1 and older"))
and it works except when it is December, then I get a "13/1 and newer" result.
How else can I phrase this to just use the correct months?
In Excel...
I need to have several table linked together and know the source of the data. Is there a way to have one of the fields contain the file name from which some of the data is pulled?
Someone told me if I create a worksheet in Excel 2007 and use the Publish feature to Create Document Workspace the Sharepoint that is created can not be shared by mulitple users although the Excel file is. Is that correct? It just seem to me the whole foundation of Sharepoint is multiple users...
I don't get the sheet back after it has been modified by the team members so the macro wouldn't be run by me. I'm currently using the info found at
http://www.cpearson.com/excel/ListFunctions.aspx
http://www.cpearson.com/excel/NoBlanks.aspx
although removing blanks is very slow. And then...
SkipVought
Pivot Tables cannot be refreshed when the sheet is shared. I love Pivot Tables. I tried.
Deniall
Thanks for this. I'll give it a try.
In the meantime I found something that appears to work. Removing the blanks is very slow so the solution is not ideal...
Yes. What I am trying to do is exactly the results you get from a pivot table. However, the sheet has to be shared and updated in real time so a pivot table is not available. Neither is the Remove Duplicate because of the sheet being shared.
I don't need to know the number of times the name is on the list. I need to create a list of names.
Names Correction Steps Req
Needed Corrected Assist.
----------------------------------------------------------
Kim 0...
I have Excel 2007. I can't use the Remove Duplicates or Filter functions because I send the sheet out to team members and the file is shared. The formula needs to update in real time as the team members make changes to the file.
I create a list of error messages and send it out to a group to make corrections. They enter their name into column A using the drop down box and they enter what they did to correct the error in column B. However, we are expanding and now in addition to the name in the drop down list we have to...
I discovered how to pull unique values from a list of names by using:
{=IFERROR(INDEX('Daily Fails'!A:A,MATCH(0,COUNTIF($B$1:B2,'Daily Fails'!A:A),0)),"")}
but it runs much too slow.
Is there another way to pull only unique values from a list of indeterminate length? I'm working with names...
I've created a very complex pivot table which I want to convert to formulas. I have everything completed except for the filters. If there is an option chosen in the filters there's not a problem, but if the user does not choose an option and wants to view all the data for that filter and maybe...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.