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?
Click to expand...

Please post the SQL of your query.
 
Top