how can i create a consolidation script

[Jordan2000]

I am building a tool,

This is wat is has to do.
the usser can import anny data. this works fine.
after that the usser has select wat to do with te data.
like a consolidation on artikel ore week. year..
so the tool has to be dynamic.

I know how to do the importing and make the query's
but the usser always want a diferent query so i want to give the usser
a form where he can select wat to query. like a advanced search form.

if it is not clear i can build a form with wath i want. that te usser wants.
i need a dynamiq select query in vba.

hope it it cleare else let me know.

 

[aleb]

Why don't you just remove the standard menues and let the user get into the free design of a query ( letting him use the query design tools )

 

[Jordan2000]

The usser has only a runtime version

 

[aleb]

The courtesy of Terry Kreft and Dev Ashish

 

[Robert88]

Hello Jordan 2000,

Maybe the attached sample search might help?

With not knowing specifically how your queries are to be structured it makes it hard, but I found this a good example to sort of do what you are doing.

It has quiet a lot of VBA in it.

Good Luck and hope it helps.

Robert88

 

[Jordan2000]

Thanks, This wil help me to build the selection form.

I want to give the usser a tool so he can select between diferent date's and catogories. and give a average salles between a average week and a action week. i build the query but you know the usser always want to build there one and is not able to do so. so they come back and want you to build a other query.

and thime is Somting that is rare here. But Thanks fore the input. this is kind of sellection tool i needed.