sorting data in a report

[David]

Hi Duane,

Here is the row source on the current powers report:

SELECT [Clients].[Client Code], [Clients].[Client name] FROM [Clients] ORDER
BY [Client name];

Here is the client name lookup field on the powers of attorney table:

SELECT [Clients].[Client Code], [Clients].[Client name] FROM [Clients] ORDER
BY [Client name];

I suspect the problem is the "client code" part but I can't get rid of it
without losing that data so it must be necessary.

best regards,

David

Lookup for officer's name, office being the appointed attorney on the powers
of attorney form:

SELECT [Officers].[Officer Name] FROM [Officers]

 

[Duane Hookom]

"The row source on the current powers report" suggests a combo box that
would display the client code or name. This would depend on the column
widths property. The Bound Column property as well as the Control Source of
combo box determine which record in Clients is displayed. If the control
source value can't be found in the Bound Column then your combo box might
not display anything.

Your statement:
====================
Lookup for officer's name, office being the appointed attorney on the powers
of attorney form:

SELECT [Officers].[Officer Name] FROM [Officers]
====================
suggests you are storing or attempting to store the text name field.

I suggest that you
- get rid of all lookup fields in tables.
- Only store a text name in one table in one record.
- Store the code or ID value in all related tables.
- Use combo boxes on forms to select a code to insert into your related
tables.
- Join "lookup tables" into the record source of your reports
- add the text field from the lookup tables in reports to display the proper
values

--
Duane Hookom
MS Access MVP
--

Hi Duane,

Here is the row source on the current powers report:

SELECT [Clients].[Client Code], [Clients].[Client name] FROM [Clients]
ORDER
BY [Client name];

Here is the client name lookup field on the powers of attorney table:

SELECT [Clients].[Client Code], [Clients].[Client name] FROM [Clients]
ORDER
BY [Client name];

I suspect the problem is the "client code" part but I can't get rid of it
without losing that data so it must be necessary.

best regards,

David

Lookup for officer's name, office being the appointed attorney on the
powers
of attorney form:

SELECT [Officers].[Officer Name] FROM [Officers]

Can you view the SQL of your report's record source and copy it into a
reply?
Do you still have any "lookup fields" in your table designs? If so, can
you
find the properties of these fields to share with us?