Parameter query problem

  • Thread starter Thread starter Mark
  • Start date Start date
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.
 
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.
 
Back
Top