Search results for query: *

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

...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... Yogi: Here's what I'm hoping to get it looking like: *this is the same data as the first screen capture, but only the first 10 records.

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

...*the hyphens are for blank fields What I need to do is sort the spreadsheet so that for each unique Id, all the Type A's corresponding amounts are in one column and all the Type B's corresponding amounts are in the next column, and so on and so on. Any ideas?

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.

thanks for the reply. i already checked that. i've found out that you can't change the labels with the legend property but i thought that there might be another way of doing it. i was able to do it,throught code, by changing the row source of the chart but only on a form and not on report, as...

ok, i hate access. i was able to modify the row source of the graph through code when it's on a form but i can't modify it when it's on a report. for the love of god!!!! why? jerry.

anyone? aaaaaaaaah! jerry.

is it possible to have the legend be dynamic? jerry.

i have no idea where to put said code. perhaps i am going about this the wrong way. i have a bar graph on a report and a query as the row source for this graph. i am trying to make the graphs's legend dynamic. since the legend labels is the column heading of the chart's datasheet which in...