report's groupage

[stax_77]

Hi, I'm an Italian man and I'm sorry for my English but it is a little bit rusty.



Good morning to everypeople. I hope we could help ourselves.

Now I'm going to explaine my idea.

I need to create a report with sub-total group from a query. I Know: it doesn't a problem but ...
... but this query has a strange format.

I've put day's lines and code's lines together. It was the only way to make my job.

Example:

colums:
CODE - DESCRIPTION ....
....
dates:
DAY - 15/02/2009
UTRD - PIPPO
67RT - PLUTO
567Y - MINNI
DAY - 16/03/2009
TRE4 - PAPERINO
WQR - BASSOTTO 167-761
....

DAY description is put into CODE's colums and value's DAY is put into the DESCRIPTION's column too.

I need to make a groupage (sum) for each day.

I thought to create a variable (for example DAYINCR) and to allocate herself to each line. It will change when change value's DAY

DAYINCR - CODE - DESCRIPTION ....
....
body:
15/02/2009 - DAY - 15/02/2009
15/02/2009 - UTRD - GOOFY
15/02/2009 - 67RT - PLUTO
15/02/2009 - 567Y - MINNI
16/03/2009 - DAY - 16/03/2009
16/03/2009 - TRE4 - PAPERINO
16/03/2009 - WQR - BASSOTTO 167-761
....

With this trick I can create an easy groupage for each oparation. But I shall to create a new query when data changes to update my report.

Because source tables are linked.

I know, i'm not a leader to use ACCESS 2007, maybe It coult exist another way or automatic function to solve this problem.

Whay do you think?

If some thread exists please don't hesitate to link myself. I look for it but I didn't find anything.

I'm sorry in advance for each mistake I've written.

[NassauBob]

Buon Giorno!

May I ask why your description column contains DAY? I really think you should not have dissimilar data in the same column - that will always cause problems.

Maybe the columns could be as follows:

DAY CODE DESCRIPTION
---------------------------------
15/02/2009 UTRD GOOFY
15/02/2009 67RT PLUTO
15/02/2009 567Y MINNI
16/03/2009 TRE4 PAPERINO
16/03/2009 WQR BASSOTTO 167-761

Now the column data are consistent, and queries can function as desired.

Does this help?

va bene!