Search results for query: *

Getting rid of the extra space worked perfectly. I'll figure out a way to have add back in a little extra space through some trial and error. Thanks Mike, JRB, Dan, Olaf and Tamar for all your help. Even if some of the advice didn't lead me to this particular solution, it definitely helped my...

Ctrl-A didn't reveal anything that I was missing. I'll tighten it up as suggested (or insert something and disappear it) and report back. Thanks, Tamar and Olaf. Sam

Okay, I'll give the Set Filter To idea a shot. But it looks like I'm running out of real options. On reading Mike's function idea again, I understand it a little better (I think). The select statement is what I would do if I had access to the code from the report (which I don't). I think...

Hello, JRB: There's a way to define the tables for the form builder, but you're right that it seems to seriously limit my options--I can say which tables, but I can't DO anything with them. See the attached image for the dialog boxes. I've used Chrystal Reports before (years ago) for a...

Olaf: I tried the "Print When" method again and all the fields disappeared but the blank lines are still there. Everything is set with "Remove line if empty." Puzzling. JRB: The vendor has included a custom reporting tool that allows me to create reports outside of their canned reports. From...

Thanks, Olaf. I'll give that a shot. I did finally notice a "code" menu item, which is in the context menu if I view the data environment from a report. But it's grayed out. I've talked to the vendor a number of times and they're not always that helpful. I might be able to beg them for a...

Thank Mike and jrbbldr. Conceptually, that seems to make the most sense--prepare or stage the data if you will and feed it into the report. I'm pretty sure I don't have access to the code. Would there be some type of shell that allows commands? Is this something that would be accessible from...

Hi, I'm trying to create a report that has some fields from a parent table in a group band and for each of those records, display some related records from a child table. But I only want CERTAIN records from the child table in the detail (due_dt>{07/01/2010}) I'm on a pre-packaged database...

Okay, that worked. Thanks dhookom! A few notes that bear mentioning for the benefit of novices like myself: My two tables in question were: "tbl_actions" and "tbl_action_type"; I originally created the combo box in a form using the wizard, and in the last step, where it asks you if you want...

Hello, I have a form with several combo boxes, each based on a table. I dutifully included an index as primary key for each table. Seems to work fine in form views, but when I try to display the field as part of a report, the report shows the index (i.e. "2") instead of the text field in the...