Grouping/Sorting levels 1

[Fredgarner]

I work for an investment management firm and have a report that lists investors by the intermediary who introduced them. It lists only investors who have come to us through an intermediary. I have made a duplicate of it and made it sort by investor - however, the report still only lists those investors who have been introduced by an intermediary, even though it now does it in investor order. Can I make it list those investors who have not come through an intermediary, as well?

 

[mp9]

You need to take a look at the record source of the report - this may be either a table, query or SQL. This source will probably do the intermediary restriction.

http://www22.brinkster.com/accessory/

 

[Fredgarner]

No, I have already looked at the Record Source- there are no filters or restrictions applied. Does anyone have any other suggestions?

 

[dhookom]

Set the join in the query to include all investors. The other option is to create a main report based on the investor table only. Create a subreport to display your required details. Add the subreport to the detail section of your investors report and link the investor ID field in the Link Master/Child properties.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Fredgarner]

Does anyone know if I can design a command button that navigates to a new record in a report, rather than using the asterisked arrow button- I am tring to make the database foolproof and some of the users will need a button which spells out to them that this is how to navigate to a new record.

 

[dhookom]

The only sample code that I am aware is from Stephen Lebans

http://www.lebans.com/controlreports.htm.

I don't know if this will work for you.

As a last resort, you could find smarter users ;-)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]