Search results

So close . . . Thanks for your reply. That worked very well!! :-)

Thank you! That should do the trick. Thanks so much!

Any further help? Hopefully someone can offer some additional help?

More help, please? Sorry to be a pest, but I'm wondering if anyone else can help me with this problem. Since I don't know Access, but have to work on this report, it's kind of been a crash course and I can't quite understand the options with the Iif function that quite meet my criteria. Thanks...

Details properties? GaryPanic: Thanks for your reply. I am so new to MS Access that I'm not sure what you mean by details properties. Can you point me in the right direction? I currently have data in the control source of my textbox. Thanks in advance for any further assistance :)

Hmmmm.... :confused: Bob Larson: Thanks for your help. It isn't the separate line that's the problem - - at least I don't think it is? The problem is that I only want to block 'Circ' from displaying and not any other data in that same field (like Ref or PF, etc) or any data in the other fields...

A new glitch . . . Thanks for your reply! It works, except for the fact I've found another value in just a few records in that field. Now I need the report to substitute "Online - Yes" if the field data includes either SC or DSP. I tried adding an 'Or' statement in various configurations to...

Almost . . . Thanks so much for your reply - - your solution almost works :) When I enter it into my report, sure enough, Circ does not display and Ref does. The problem is that none of the other field data displays when the location is Circ. Typically, when the location is Circ, there is a...

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...

Thank you! Thank you both so much for your help. I tried stopher's solution and it worked like a charm :) I think I even have the slightest idea why ;) Is there anyway to solve my second question about not having 'Circ' appear in the location field and only having 'Ref' appear? Any further...

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...