Custom grouping of a query records

[aonsu209]

Dear all,



I'm making budget report for the company that I work as engineer not IT. Therefore I'm not so good with programming, but I can handle some. I need to create two types of budget reports. For one of the type I need to create a custom group query (see picture below). Is that possible and if it is any suggestions? (In my mind is something as extra calculated columns in the query and group it by them)


For the second type the problems are two I still need to group it, but also is a crosstab query and I need to fix the columns if I want it as subform. But on the way of working always should show the latest week, which means I can't fix the columns.


Thank you in advance!

[ranman256]

These reports can be made via CROSSTAB queries.
tho yours are a bit complex, it can be done.
you may have to post various crossatabs to a 'report' table, then run the report.

[aonsu209]

Thanks I get the idea, but what about for the second type, the crosstab query(subform) always need fixed column headings although there is a variable?

[ranman256]

the 'report' table, would have these columns. Various append queries would add records to this table into their respective columns.

[aonsu209]

the 'report' table, would have these columns. Various append queries would add records to this table into their respective columns.

Thank you so far with your input I'm trying it now. But I met another difficulty, I want to create a query with if statement, that should select tha last two records only. And because is in if statement I can use the option SELECT TOP2.. .I add row number to help me out, but still I need help how to do this if statement.

What I want is something like that: rownumber: IIf([rownumber]<=3,[rownumber]=1,Sum([rownumber]-2)).
If the rownumber is smaller or equal to 3 rows to show the first row if it is not true to sum all the raws excluding the last two.