Search results

I have a solid line separating records in my report. Sometimes the solid line immediately follows the text of the record above and sometimes it seems to leave an extra line. Any ideas what is causing this extra space? Thank you :confused:

Sorry, another question kind of related to my last one: In the location field, there can be two values: Circ or Ref If the value is Circ, I do not want this data to display on my report. If the value is Ref, then I want the report to say Ref. Please note that I am currently displaying this...

I'm still working on the same report as mentioned in my last post about eliminating extra lines. Now, I want to substitute text in one of the fields. The online availability field will either contain 'SC' or nothing. If the field contains 'SC', I need it to say something like 'Online - Yes'. If...

Hello, I'm very new to Access - - I don't know much about it except I've been asked to create a report from an already existing DB. In my report, there are 4 fields (location, call number, online availability, subject) that can sometimes be empty. They appear one above the other on the right...