I’m trying to configure a report from a query. First things first, my query I’m trying to create has about 18 fields, of these fields four are photos (jpeg) of certification classes. In my query I’d like to have a “Y” or some designation indicating the record has done the certification. For those that have no certification form that field is blank on the database entry form.
This is a split database. This is on a Windows platform:
Version: 126.96.36.199 (x64)
Build ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; Layout Engine: new;
Locale: en-US (en_US); Calc: group
I’ve been able to create a report that is almost what I need. Attached is a screen shot of two records from the report: example.jpg
Notice the IS-100, IS200, etc. fields. In the first record this person hasn’t completed the task and received the credentials so in the master form entry there is no data for these fields (blank). In the second record this person has completed those tasks and the location of the file, which is a pdf file, is input into the entry form and stored in the database. My query I use to run the report filters on fields being blank or not and when the report is run the picture is what I get. It’s almost what I need, rather than the file location as is shown I’d like the report or the query to display a Y or 1 or some other short designator rather than what is shown in the report. Is that possible to do? I’ve tried various functions and none seem to work.
Final Update: Thanks for suggesting of adding another field to indicate if the certification form was done by the member (record). That was the easiest thing to do. I tried many different filtering and test criteria and all failed so finally added the extra field of “Y” or “N” and filtering became so much easier.
Look for my post on reports with filter criteria.