ask for parameter ?

[pdm]

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.

[pdm]

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 ?

[Jana]

On Feb 27, 8:05 am, [e-mail] 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

[pdm]

thanks Jana - simple but effective, it works !

[Jana]

On Feb 27, 9:23 am, [e-mail] wrote:

thanks Jana - simple but effective, it works !

Yay! You're quite welcome ;)

Jana