Parameter query question

  • Thread starter Thread starter steve goodrich
  • Start date Start date
S

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
 
Hi steve, it looks as though the parameter is still set up, go into Query,
parameters and remove it.

Stu
 
steve goodrich said:
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
Click to expand...

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

Keith.
www.keithwilby.com
 
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
stumac said:
Hi steve, it looks as though the parameter is still set up, go into Query,
parameters and remove it.

Stu

steve goodrich said:
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
Click to expand...
Click to expand...
 
I aint sure, I never use that parameters box I dont declare them at all as
they aint required.

Stu

steve goodrich said:
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
stumac said:
Hi steve, it looks as though the parameter is still set up, go into Query,
parameters and remove it.

Stu

steve goodrich said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top