queries in linked databases & 'no current record' message

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

I am working on a linked database. I noticed that a few
of my queries are coming up with a statement of 'no
current record'. In investigation, I noticed that it
seems to be queries that are using a table join of "show
all from table X and only those records from table Y where
the joined fields are equal" and one of the fields used in
the query from table Y is a Yes/No checkbox. Though if I
use any text field from table Y, the query works. Does
anyone know why this might happen and how I can still use
the yes/no checkbox in my query for use in a report?
 
Well with out seeing your query in its entirety, have you
tried putting true or false in the Criteria field for the
check box field?

A very wild guess,
Marty
 
Back
Top