Criteria duplication in RUNNING A QUERY

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a question which seems just to be a matter of that I am an ACCESS-novice and doesnj't have to be considered a real problem...

I found this trying out Date formatting functions - Format() and DatePart.

I have a query where the first column is [Datum] + group by, the second is Format([Datum]) returning week number and the third is DatePart([Datum]).
For first column is a criterion set 'Between [from] and [to]'.

When I run the query a pop-up window appear:

Enter parameter value [from]
Enter parameter value [to]

.....no problem. But afterwards again these pop-ups appear once again.

Can anybody explain me why? Thanks in advance.
 
Hi Richard,

Is there a chance that when you were viewing
the results of your query, you applied a sort on
one of the columns?

To test if this is the case, run the query, and while
viewing the results, click on Records/Remove Filter/Sort
in top menu. Does the "repeat" go away?

If you need to sort your results, it is best to do it in
the Design View using the Sort row.

Please respond back if I have misunderstood
or was not clear about something.

Good luck,

Gary Walter

Richard said:
I have a question which seems just to be a matter of that I am an ACCESS-novice and
Click to expand...
doesnj't have to be considered a real problem...
I found this trying out Date formatting functions - Format() and DatePart.

I have a query where the first column is [Datum] + group by, the second is
Click to expand...
Format([Datum]) returning week number and the third is DatePart([Datum]).
For first column is a criterion set 'Between [from] and [to]'.

When I run the query a pop-up window appear:

Enter parameter value [from]
Enter parameter value [to]

....no problem. But afterwards again these pop-ups appear once again.

Can anybody explain me why? Thanks in advance.
Click to expand...
 
Hi Gary,

You were right.... Now I understand!

What I did was:

1. Design a query
2. I run a query and sort by one of the column in "datasheet view" mode
(Records / Sort Asc. resp. Desc.)
3. Saved the query

The query was saved with the sort option set by the Access not the SQL...

Thank you again for the information....

Gary Walter said:
Hi Richard,

Is there a chance that when you were viewing
the results of your query, you applied a sort on
one of the columns?

To test if this is the case, run the query, and while
viewing the results, click on Records/Remove Filter/Sort
in top menu. Does the "repeat" go away?

If you need to sort your results, it is best to do it in
the Design View using the Sort row.

Please respond back if I have misunderstood
or was not clear about something.

Good luck,

Gary Walter

Richard said:
I have a question which seems just to be a matter of that I am an ACCESS-novice and
Click to expand...
doesnj't have to be considered a real problem...
I found this trying out Date formatting functions - Format() and DatePart.

I have a query where the first column is [Datum] + group by, the second is
Click to expand...
Format([Datum]) returning week number and the third is DatePart([Datum]).
For first column is a criterion set 'Between [from] and [to]'.

When I run the query a pop-up window appear:

Enter parameter value [from]
Enter parameter value [to]

....no problem. But afterwards again these pop-ups appear once again.

Can anybody explain me why? Thanks in advance.
Click to expand...
Click to expand...
 
Back
Top