I'm writing an application for membership maintenance, part of this is to record if a member is deceased.
The data is stored in an access 2007 database (accdb), the deceased field being of 'Yes/No' datatype with no default value.
In Access I can write SQL to retrieve rows where deceased = true or deceased = false, the expected rows are retrieved.
The next step was to create a crystal report, adding the database connection and the report layout.
When running the preview WITHOUT ANY selection/paramater criteria ALL rows are retrieved with the deceased column printing the words True or False.
Now the headache (looked at this for over 24hrs now!! arghh) is if I use the select expert to find rows where deceased = true NOTHING is returned. Where deceased = false retrieves rows.
The same with selection formula for a record, retriews ROW if deceased clause isn't present or deceased = false.
Sometimes, the deceased = true clasue will bring back the true records ONLY, however if I refresh the row disappears.
Originally I thought this was a vb.net code issue until I stripped it back, testing the data retireval in crystal reports.
So I know 100% its connecting to the database, has rows with values of both True and false in the deceased column.
This is confirmed when ALL records are show on the report.
Can anyone think what the problem might be? A bug? A setup issue?
It just won't retrieve rows where deceased value is TRUE.
Happy to send application over for closer inspection.
Really frustrated and confused.