Recent content by John1Chr

Duane, worked great - your suggestion..thanks!

C F and I are heiarchal aggregations of the Base and Adjustments. I am trying to have a Name of the Cumulative displayed that pulls in the 2 pieces of that Aggregated Total. This name would tie out to pieces underneath it. I wasn't clear, sorry.

Thanks, I might be overthinking this one. I wanted to display 2016C in listbox but really it is In ('2016A','2016B') and display 2017F which really is In ('2016D','2016E') and display 2017I which is really In ('2016G','2016H'). I was desiring to use these names which would be obvious to the...

I desire listbox to display this format: 2016A(Base) 2016B(Adj) 2016C(2016A(Base)+2016B(Adj)) 2017D(Base) 2017E(Adj) 2017F(2017D(Base)+2017E(Adj)) 2017G(Base) 2017H(Adj) 2017I(2017G(Base)+2017H(Adj)) How do I get code to build query to recognize 2016C, 2017F and 2017I and feed query as...

In nutshell want to relate a header to detail underneath it. Header FY2012 Load_Actual Prelim ZA70010 Detail APZ #Mi 1892.517 #Mi RFZOUT #Mi 292.72942 #Mi 51000 #Mi 1214.09399 #Mi 51030 #Mi 124.18024 #Mi 51050 #Mi 0.19638 #Mi FTE #Mi 24.57461 #Mi This info is related to the header...

Yes, I did not make it clear. I am working in access off of a text file - space is used to separate fields. I am linking to the text file and I have a query that I am running against the linked text file through access. I was thinking of using first field in query to relate data but am not...

Hmmmm...maybe...2 million records though. I went into text file and deleted/find-replaced unnecessary spaces characters. Huge file...got it down from 88MB to 77MB. I have it set up / linked in access in format above. Is there way to handle such large file in excel? Might be slick to see...

Yes, that is correct. It is in access but I just put it in excel to try to explain what i was facing. When B changes FY those records below it are related to that header. Basically, file is sorted so that headers have related data below but those rows do not have relational record.

I have a table that is over 2 million records froem a text file and I think, but not sure that the best way to relate fields is to create column and insert the relating paramters in a row in a new column A. I am able to sort the file so that everything Below the FY20XX relates to the column...

Yeah at the end...crud. I was trying to sum up by date the total expenditures. Really, I would like to sum everything up by acceptance date. And really everything > 2/11/2010. I don't need transaction number or transaction line number. Yes, would have many of those per date so couldn't use...

Greetings, I'm having trouble using the running sum code in a query. It errors out on the code on Select Case rst.Fields(idName).Type and error is ITEM NOT FOUND IN THIS COLLECTION. My query SELECT t1.ACCEPTANCE_DT, t1.EXPDTR_AMT, t1.OBJ_CD, t1.TRANS_LINE_NBR, t1.TRANS_NBR...

Here is a more detailed explanation - I added a new table third table and am linking to the other two detail tables. 1 to Many relationship to both tables. SQL is below. The issue that I have is that the APPROP(ie.budget) table has one DEPT_BUDGT per year but the salary proj table has the...

Trying to solve with running total thinking that somehow I need to keep the employee ids from duplicating and accounting periods from duplicating at the Dept Budget level in those tables and then sum up.

Sorry....haven't used the view (stored procedure). I want to ensure that this can be converted to crystal 11 and that I can feed parameters into the report for the first 3 characters of dept budget, fund and fiscal year and account. I didn't mention but I will also be filtering and comparing...

I think you're right - running total will work. I googled a little and saw that this can be done by formula. I'm struggling with agregating both tables to the Dept Budget level so that I can compare. I'm trying to use the running total field and I am evaluating by change on Dept Budget(CF3)...