Recent content by NuggetInc

dhookom, That worked great! Thanks for your help! But I still don't really understand how that actually works. Is there some documentation out there that explains this. I have several access developers books and couldn't find what I was looking for. Is there a process or name for what you...

I'm still having problems...heres the entire sql statement: PARAMETERS [Forms]![SalesBySlsmDialog]![BeginYear] Long, [Forms]![SalesBySlsmDialog]![Month] Long, [Forms]![SalesBySlsmDialog]![Salesman] Long, [Forms]![SalesBySlsmDialog]![MfgCombo] Long; TRANSFORM Sum([All-Mfgs_All-Reps...

dhookom, I don't understand your line: I would set the Column Headings to ColHead: "Yr" & [YearField]-[Forms]![SalesBySlsmDialog]![BeginYear] By column heading do you mean Field:? and [YearField], what does that represent? (Do I replace that with the year field from my table, the year field...

Here is the where clause: WHERE ((([All-Mfgs_All-Reps Query].MonthID)<=[Forms]![SalesBySlsmDialog]![Month]) AND (([All-Mfgs_All-Reps Query].Year)=[Forms]![SalesBySlsmDialog]![BeginYear]) AND (([All-Mfgs_All-Reps Query].ImployeeID)=[Forms]![SalesBySlsmDialog]![Salesman]) AND (([All-Mfgs_All-Reps...

One more thing: The below text worked fine for summing the DOMAIN (grand total of all months), but I want to break out the months seperately (jan, feb, mar,...): Prior Year: IIf(DSum("Amount","All-Mfgs_All-Reps Query","Year=" & [Forms]![SalesBySlsmDialog]![BeginYear]-1 & " And MonthID<=" &...

dhookom, I did that and I get a blank column for 2003, and #s in the 2004 column. You may also need to know that the user picks the beginning year, and I want to calculate that year's numbers and then compare them to the previous year's numbers. The problem I'm having is how to get two sets...

JonFer, Thanks for the input. But won't that give me the combined results for last year and this year? What I wanted (and wasn't clear in my initial post, sorry) is two columns, i.e. : month 2004 2003 jan $100 $50 feb $150 $100 mar $500 $350 ...

I'm tring to sum up sales figures by month (there are several entries for each month) using a crosstab query. That part is working fine - I get the months, and the total sales from all customers for that month. What I also want to do is calculate last year's figures in the same crosstab query...