Querying Tables with Yes/No data types

G

Guest

Hi

I am trying to query a table with Yes/No data types in it and keep getting
either -1 or 0.

Is there a way to change these values back to Yes or No, so they appear
correct in a report?

Thanks
 

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

Similar Threads

Report on a Query with Yes/No data types 4
Delete Query: Could not delete from specified tables 0
IIF Function Within A Query 6
Using a Yes/No field to trigger a calculation in another field - J 3
Yes / Yes + N Responses for percentage 4
Access #Error & Excel Pivot 0
YES /NO Query 1
Access Dcount (multiple criteria) 3

Top