Search results

I'm running report where some data points require information to be displayed in a subreport. However, where there is no data to display, the area occupied by the subreport take us space (read: leaves big chunks of blank space) on the report. Is there a way to "Can shrink" or "hide" blank...

Thanks Peter, I think that's got the query working. I still don't understand why the data is not stored in the format: RFA-0001 even though that is how I specified the input mask...

I have data recorded using an input mask, "RF">L\-0000;;* to display data in the style: RFA-0001, RFA-0002 etc. I have a make table query to join this field to another, to create a combo box look up. Unfortunately, after I run the query, the only data from the input mask that gets imported is...