Parameter query question

[steve goodrich]

I have a very simply query set up
due_date name
in the criteria for the due_date I have [Please enter date] I enter the date
to see all names that are due for the date entered (simple)
I now removed the criteria so it will show all dates, but I still get the
parameter box popping up asking for a date!!
There is no criteria anywhere
I could delete the query and set up another but I'm curious to know why it
won't work
any ideas

 

[Guest]

Hi steve, it looks as though the parameter is still set up, go into Query,
parameters and remove it.

Stu

 

[Keith Wilby]

I have a very simply query set up
due_date name
in the criteria for the due_date I have [Please enter date] I enter the
date to see all names that are due for the date entered (simple)
I now removed the criteria so it will show all dates, but I still get the
parameter box popping up asking for a date!!
There is no criteria anywhere
I could delete the query and set up another but I'm curious to know why it
won't work
any ideas

Do you have any calculated fields requiring "[Please enter date]"?

Keith.
www.keithwilby.com

 

[steve goodrich]

Hi Stu
Thanks for the info, I did as you suggested and it was indeed still there, I
deleted it and all is well.
Do you know of a reason why the criteria was not removed by me deleting in
the normal way
Many thanks
Steve

Hi steve, it looks as though the parameter is still set up, go into Query,
parameters and remove it.

Stu

I have a very simply query set up
due_date name
in the criteria for the due_date I have [Please enter date] I enter the
date
to see all names that are due for the date entered (simple)
I now removed the criteria so it will show all dates, but I still get the
parameter box popping up asking for a date!!
There is no criteria anywhere
I could delete the query and set up another but I'm curious to know why
it
won't work
any ideas

 

[Guest]

I aint sure, I never use that parameters box I dont declare them at all as
they aint required.

Stu

Hi Stu
Thanks for the info, I did as you suggested and it was indeed still there, I
deleted it and all is well.
Do you know of a reason why the criteria was not removed by me deleting in
the normal way
Many thanks
Steve

Hi steve, it looks as though the parameter is still set up, go into Query,
parameters and remove it.

Stu

I have a very simply query set up
due_date name
in the criteria for the due_date I have [Please enter date] I enter the
date
to see all names that are due for the date entered (simple)
I now removed the criteria so it will show all dates, but I still get the
parameter box popping up asking for a date!!
There is no criteria anywhere
I could delete the query and set up another but I'm curious to know why
it
won't work
any ideas