B
Billiam
I am using the following to produce a "stacked Style" name address field for
a report:
StackedLastMidFirstAddressCITYALPHA: Trim([LastName]) & ", " &
Trim([FirstName]) & " " & Trim([MidName]) & "," & Chr(13) & Chr(10) &
[TblFSESO]![Address1] & ", " & IIf(IsNull([TblFSESO]![Address1]),Null,Chr(13)
& Chr(10)) & [TblFSESO]![Address2] &
IIf(IsNull([TblFSESO]![Address2]),Null,Chr(13) & Chr(10)) &
[TblFSESO]![Address3] & IIf(IsNull([TblFSESO]![Address3]),Null,Chr(13) &
Chr(10)) & [All Active CITY Alpha sort]![City] & ", " & Chr(13) & Chr(10) &
[TblFSESO]![Province] & ", " & Chr(13) & Chr(10) & [TblFSESO]![Postal Code]
The query shows me what I want in datasheet mode (Name and address stacked
and the city sorted a to z.
When I try to produce a report using the
StackedLastMidFirstAddressCITYALPHA, it does not provide the same info...it
sorts by the ON#, not by the city as it shows in the query that I am basing
the report on. I have checked to insure the record source is for the query, I
have tried just producing a report based on the query (automatic), and
nothing is working....
Just to clarify, I want a stacked name address that is sorted alphabetically
by city name....
Thank you for any help,
Bill
a report:
StackedLastMidFirstAddressCITYALPHA: Trim([LastName]) & ", " &
Trim([FirstName]) & " " & Trim([MidName]) & "," & Chr(13) & Chr(10) &
[TblFSESO]![Address1] & ", " & IIf(IsNull([TblFSESO]![Address1]),Null,Chr(13)
& Chr(10)) & [TblFSESO]![Address2] &
IIf(IsNull([TblFSESO]![Address2]),Null,Chr(13) & Chr(10)) &
[TblFSESO]![Address3] & IIf(IsNull([TblFSESO]![Address3]),Null,Chr(13) &
Chr(10)) & [All Active CITY Alpha sort]![City] & ", " & Chr(13) & Chr(10) &
[TblFSESO]![Province] & ", " & Chr(13) & Chr(10) & [TblFSESO]![Postal Code]
The query shows me what I want in datasheet mode (Name and address stacked
and the city sorted a to z.
When I try to produce a report using the
StackedLastMidFirstAddressCITYALPHA, it does not provide the same info...it
sorts by the ON#, not by the city as it shows in the query that I am basing
the report on. I have checked to insure the record source is for the query, I
have tried just producing a report based on the query (automatic), and
nothing is working....
Just to clarify, I want a stacked name address that is sorted alphabetically
by city name....
Thank you for any help,
Bill