Parameter query problem

M

Mark

I have set up two parameter queries in my query to limit
the data to groups of latitude and longitude, using the
Between [blah:] And [blah:] criteria. The criteria are
identical for both types.
When the query is processed the results are correct for
longitude but show all the values for latitude.
How do I correct this?

I have put Is Null functions in the or field to give all
data if parameters are left blank.

Thanks in advance,
Mark.
 
J

John Vinson

I have set up two parameter queries in my query to limit
the data to groups of latitude and longitude, using the
Between [blah:] And [blah:] criteria. The criteria are
identical for both types.
When the query is processed the results are correct for
longitude but show all the values for latitude.
How do I correct this?

Please post the SQL of your query.
 

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