Unanswered: Access reports from MySQL data via ODBC? Help!
I am having some problems with Access reporting using linked tables from MySQL. I am hoping someone can answer a couple questions regarding data types and the like.
First, how can I display a character on the Access report using a condition? In this case, the Jet (Access) Boolean data type is equivalent to the MySQL TinyInt data type. How can I display a dot or a "Y" in my report if the value of the field is "1" (True) in the DB? I am somewhat new to Access reports, and my past experience in Access is mostly VBA.
Second, why are date fields that are listed as [NULL] in MySQL CC being displayed as "1" in my access reports? This makes no sense, but I am sure there is some obscure reason for it.
By the way, I am using MySQL 4.0.18 and Access 2002. My MySQL ODBC version is 3.51
Actually, I am putting 'Option Explicit' at the top of my modules, but thank you for the recommendation!
I was actually able to get this one figured out yesterday, using the same thing you recommended here. It works wonderfully except at first I was putting the IIF function directly into the report, which was rendering some unexpected results. Once I realized the mistake and placed IIF in the query itself, things started moving much more smoothly.
Thanks again for the reply. I appriciate your help!