I have a simple query.In one colomn I make a new field out of two.

COLUMN
ID: [MNR] & " " & [TASK]
Group By


Finally it works, he is showing the result I espected. But there is an
a little problem. When I ask to perform, activate the query he is
asking for a parameter for MNR (MNR : in the same query, get the
monthnumber by two digits MNR: Format([DAG];"mm").

how to avoid the question to put in a parameter for MNR ? I fill
nothing in and finally the query gives a perfect result.

a step between : first I make the query : MNR: Format([DAG];"mm") and
all the other data.

I make a new query - take all the data of the previous one and add ID:
[MNR] & " " & [TASK]

But then I have to double all my queries. Its should be better that I
got my result in one single query. Any better solution ?

On Feb 27, 8:05 am, p...@patweb.be wrote:

a step between : first I make the query : MNR: Format([DAG];"mm") and
all the other data.
>
I make a new query - take all the data of the previous one and add ID:
[MNR] & " " & [TASK]
>
But then I have to double all my queries. Its should be better that I
got my result in one single query. Any better solution ?

Try putting ID: Format([DAG];"mm") & " " & [TASK] in your query
instead of [MNR]

HTH,
Jana

thanks Jana - simple but effective, it works !

On Feb 27, 9:23 am, p...@patweb.be wrote:

thanks Jana - simple but effective, it works !

Yay! You're quite welcome ;)

Jana