By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,930 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,930 IT Pros & Developers. It's quick & easy.

ask for parameter ?

P: n/a
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.

Feb 27 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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 ?

Feb 27 '07 #2

P: n/a
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

Feb 27 '07 #3

P: n/a
pdm
thanks Jana - simple but effective, it works !

Feb 27 '07 #4

P: n/a
On Feb 27, 9:23 am, p...@patweb.be wrote:
thanks Jana - simple but effective, it works !
Yay! You're quite welcome ;)

Jana

Feb 27 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.