Recent content by bstboy

Nevermind, I had text wraps when I needed number wraps on the Year criteria.

This is code to run a filter on a report using two multi-select list boxes. It was working fine before, and then I changed the [FY] or fiscal year data in all associated tables from text to number, and now it won't work. The debug stop on the highlighted line, not sure what that means. Let me...

Awesome, that was easy enough, and it kills unneeded queries and tables.

Thanks for the help. I did it the same, but different yesterday. I'm not familiar with union queries so I created 4 Make Table queries and then appended them into a master table. Looks like the end result is the same as your union query. Let me know if otherwise.

quick bump on this for the coding of calculating the difference in a dynamic (filtered) report.

Thanks, I see what you did and I'm almost there. However I'd like the prior years april on all fiscal years, looks like the query you build is only for 2011. So for 2010, I'd want to see the 2009 prior April, for 2011 to see the 2010 April (which you did) and for 2012 to see the 2011 April...

A little lost now. My limited knowledge says that I need the crosstab query to get the data in the format I need for my report (i.e. original data is in list format and I need time phased with months across the top for the report). Plus, I don't really have dates, it's broken out into it's...

I've attached a sample of my DB. The report is off of a query right now.

Please see attached to help understand what I'm trying to do. I'd like to calculate a 13 month average May - April, with the 13th month being the previous year's April (so essentially April to April). How can I add that previous month's April to the detail of the report. I've also attached...

Difficult enough coding to not bother with it? I don't want to make this overly complicated however it would be a nice feature. Like I said before, I know zip about coding. Anybody willing to help?

I got the FY text boxes to show the correct values however the difference calculation is netting to zero across the board, as if it's not recognizing the values and doing 0 - 0. I actually think it sees txtMay2010 and txtMay2011 as Null values even though they are showing values in the FY...

Correct on your assumptions above....yes 2011-2010

It's grouped by Product and then Sorted by Fiscal Year. So I've changed it to group by Fiscal Year.

I read the page, yes.

Hopefully this helps