Enter Parameter Value?

M

megankathryn

I am trying to run a query which was previously made up by someone else... it
has always worked in the past and now I am getting a pop up that says enter
parameter value - date...

what does this mean and what do I need to do to correct it?
 
W

Wayne-I-M

Access is expecting a date.

This could be a qriteria in the query or in a calculted column in the query

Ope the query in design view and check the criteria row to see if you can
see anything. I would NOT delete it until you are sure it's not doing
something important.

If there is nothing in the criteria row then you need to check the
calculated columns (look for cloumns that has some text as the start followed
by :)

If this does not work (and you are sure you are working on the query and not
a form or the table then select view at the top of the page and select SQL
copy this code and post it here and someone should be able to spot the problem
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top