Recent content by Sketchin

Geez, I am out of practice.... Now I see how # is being used, it is saying that everything between the #'s is a date. #" & [Forms]![frmdashboard]![txtDateTo] & "# It's been a VERY long time since I have actively developed! Thanks for the help.

I have a criteria in a DCount that says "MinOfDateout < #" and have no idea what < # is doing. MinOfDateout is a field in a query. The entire string looks like this: UNICompaniesSupportedCumulativeAB = Nz(ECount("[MaxOfContactID]", "QryCumulativeMetricsNew", "[State/Province] = 14 AND...

You are a legend! Putting it in the OnClose event will work, I just need to make sure I figure out which form I came from since there are up to 5 that the user could have came from.

I have a form that shows project details including some financial information related to my project. In order to update the financials, or add some transactions, I click a button that opens a transactions form. On that form, I enter the data required and then close it to return to my project...

I have this query expression that gives me a #NUM! error due to div/0. PercentPaybackToDate: FormatPercent(((Sum(IIf([TransactionTypeID]=5,Nz([Amount]),0)))/(Sum(IIf([TransactionTypeID]=9,Nz([Amount]),0)))),0) I can't for the life of me figure out how to test for a zero value in [Amount] to...

Alright, I think I am good for now. For some reason, sorting isnt workign in Access, but I can do it in my linked Excel Sheet. Thanks for the help!

I made an adjustment tothe calculation because the program type doesn't really matter, its just the Company Name and Engagement Date that are important. I am closer to a solution, but now am missing data! CompanyName Engagement Date ProgramType EngagementOrder 4iiii Innovations Inc...

Hi plog, Thanks for the reply. I implemented this and it didn't quite work. Here is a sample of the data output that should give you an idea of what went wrong. CompanyName Engagement Date ProgramType EngagementOrder 4iiii Innovations Inc. 1/22/2013 TAP 1...

Plog, here is a sample of the RAW data: Company Name Engagement Date Program Company A 5/9/2015 IND Company A 5/9/2016 GEO Company A 5/9/2017 TAP Company B 5/9/2015 GEO Company B 5/9/2016 IND...

Thanks for the reply. Yes, I am ordering engagements by the date field. I believe that in order to do this in a crosstab, I would first need to create a query that has a calculated field that somehow determines the number of engagement (1st, 2nd...etc.) From there, I could use that calculated...

Hello, I have a dataset that includes Company Name, Date and Program Type. I need a query that will list distinct company names in rows with 1st, 2nd, 3rd ..etc engagements as column headers and the program type as the data. Please see the attached image for a clear picture of what I need to...

Hello, I am using the following code to pull data from multiple spreadsheets in a directory tree in to one master sheet called "Results.xlsx" I would like to modify the code to only pull data from Row 3+ (until a blank row is encountered) of every sheet that contains data except the 1st...

Perhaps I'm not explaining well enough. I have a split database with the FE and BE on our internal network drive. People create their own spreadsheets and create tables that are linked to my Access BE queries. What I THINK I can do, is view all of the spreadsheets that are linked to my database.

Hello, The other day I could swear I came across an article that said a feature of Access 2016 was that you could view all of the spreadsheets that are linked to your database. Was I imagining things? I can't for the life of me figure out how to do this.

Here is the SQL as it stands: SELECT tblLookup_ProgramType.ProgramType, Sum(tblProjectTransactions.Amount) AS Commitment, tblLookup_TransactionType.TransactionType FROM tblProjectTransactions RIGHT JOIN ((tblLookup_TransactionType RIGHT JOIN (tblLookup_ProgramType RIGHT JOIN (tblProject LEFT...