Recent content by gtroiano

yogi: That did it. Thanks you so much! And thanks to everyone else who helped me along!

John: This spreadsheet is just the output from some database that I have no control over, so normalizing the db isn't really an option. If normalizing the data in the spreadsheet will help me achieve the following, I'm all for it of course. Though doing it is another matter altogether...

bluedragon2: I'm not sure I follow. Below is what the spreadsheet actually looks like. The above A, B, C version was just an example. It wouldn't fit, but the spreadsheet below actually has an additional 14 columns. The columns go from awardid1|awardamt1 to awardsid12|awardamt12. In total...

skip: The data is definitely a mess, but if it weren't I guess there wouldn't be a problem to begin with. I'm looking over that FAQ right now. I hope it helps. yogi: Not quite. The calculations aren't the problem right now. Rather that try and explain it, this is what I'm looking to reorder...

Yeah, I've been messing around with pivot tables for this, but I'm not sure that I have a good enough grasp on their use. I've got about 5,000 records and 30 or so columns of data, and it gets a little crazy looking when start with the pivot tables. Anyone know of a good tutorial online that...

I've been given a spreadsheet that looks like this: Id[tab]Type1Name[tab]Type1Amount[tab]Type2Name[tab]Type2Amount[tab]Type3Name[tab]Type3Amount 1[tab][tab][tab]A[tab][tab][tab][tab]1000[tab][tab][tab][tab][tab]B[tab][tab][tab][tab][tab]2000[tab][tab][tab][tab]C[tab][tab][tab][tab]500...

i see. thanks for the help. jerry.

MichaelRed: Apropos my previous post, what is it that the text box that gives the highest number goes to "1" when you try and compare it to the counter? jerry.

for all those who care, if anyone, i figured this out...sort of. fortunately, the number of records per group on the report is fixed so: in the on format event of the detail section of the report, i put a nested if..then..else statement using the counter's results to retrieve the last line and...

this shouldn't be too hard. perhaps there is a better way of determining the last line in the detail, because this seems to be where it get tricky. jerry.

great. thanks for keeping it in mind. jerry.

i ask because sometimes the value being underlined is a different length and a drawn line would be fixed. jerry.

i must be an idiot. that works just fine. out of curiosity, do you think the previous method would work somehow? jerry.

ok, i have a report with three group headers and footers(grants, loans, other). the detail shows the type of programs that fall under these catagories. what i am trying to do is underline the last record in each group. i tried to put a counter in the detail section(this worked) and then choose...

that is what i have done but the labels in the legend are the column headings on the chart's datasheet which are in turn what is defined in the query(Sum(qryUGFederal.PreviousAmountU) AS [2000-2001]) where "2000-2001" is the column heading/legend label. jerry.