No Current Record Mystery

[tallbarb]

User has a database with a "one" table (Projects) joined to a "many" table (Comments) by two fields: Project Number and Phase. The Project Number and Phase together are the primary key.

She created a query using both tables, included in the grid the Project Number and Phase from the Projects table and a field called PCSD from the Comments table. The PCSD field is a Logical field (displayed as a check box).

When she runs the query, she gets the message "No Current Record".

If she removes the PCSD field from the query and adds another field from the Comments table that is NOT a logical field, the query runs just fine.

She is using a join type of 2.

Would appreciate any help on what I might look at that could be causing this error. Thank you!!!

 

[JeremyNYC]

Barb,

Post the sql from both queries. It sounds like she might have a where statement in there, but we can't tell without the sql.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[tallbarb]

Actually, it is now working. This is what I did. I entered "yes or no" for the criteria for the logical field. I'm not even sure why I tried that - despiration, maybe. But it worked - go figure.......

 

[JeremyNYC]

Barb,

I would just pull the criteria out from there, instead. Same effect, cleaner, and (a tiny bit) faster.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.