Append queries problem

[Bokazoit]

Well don't know if this is the right forum but now I try

I have the following tables, queries and reports:

Table1 (with all data I use to create the queries and reports)

Table2 (Build upon 5 append queries)

Query1 (Retrieves data from table1 so that I can manipulate the data in table1

5 Append queries (Query2-Query6) that retrieves data from query1 and I manually update whenever new data is entered into table1. Ofcourse I delete table2 data before I append

Cross_tab_query (Retrieves the data from table2

Finally I use the Cross_tab_query to build my report upon.

Query1 has the follwing coloumns:

Market, SegmentID, Oms (revenue), Period

The periode is given by year and month number, so july 2004 is: 200407

In Query1 I set Criteria to '<200408' if I would like my report to show data from before August 2004.

If I do that, I have to delete data in table2 and refresh QWuery2-Query6. Then open my report to see the results.

What I would really like is to be able to open my report and then choose the period I would like to see and then table2 data is automatically deleted. When data deleted, Query2-Query6 is updated. Then my report shows the result.

Is that possible? If Yes (which I think it is) then how?

In advance tx

 

[Bokazoit]

Okey it isn't posibble or just very difficult?

 

[dhookom]

Why not open a form and then choose the period, run the queries, open the report? I prefer reports to just be for showing/displaying data. I rarely have any code running in a report that doesn't pertain directly to the format of the report.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[Bokazoit]

Well I would like my collegues to be able to use this tool without the need to learn MS Access. As is now, they can't run this tool by themselfs since they have to run the procedures described above.

So any way to do this?

 

[Bokazoit]

I can see I need some sort of VB code if it should work optimal :/

And do I suck at coding...yes :/