A
Alferd Packer
hi
company that i work in use 'access' for db managment
they ordered programmers to develop system
and everything was fine until office sp1
there is form that list addresses and you have many options
to filter results
and particularly there is option to print
but first it generates report as i understand
form works right but report generated for print does not
however it worked before sp1 install and also on of2000
here is example of code passed to generate report:
SELECT DISTINCT a.id AS Expr1, (SELECT MIN(ISNULL(t1.
name + ', ', '') + ISNULL(t2.name + ', ', '') + ISNULL(t.
name + ', ', '') + t3.name) FROM
PID_Territories t1 RIGHT OUTER JOIN PID_Territories t2 ON
t1.atvk_id = t2.ref_atvk_id RIGHT OUTER JOIN
PID_Territories t ON t2.atvk_id = t.ref_atvk_id RIGHT
OUTER JOIN PID_Territories t3 ON t.atvk_id = t3.ref_atvk_id
INNER JOIN PID_Address n ON t3.atvk_id = n.atvk_id INNER
JOIN PID_Xref_Adr_Inf d ON n.address_id =
d.address_id WHERE (d.id = a.id)) AS Ter, (SELECT
MIN(isnull(b.street_name, '') + isnull(', ' + n.nr_num, '')
+ isnull(', ' + n.nr_char, '') + isnull(', '
+ n.home_name, '')) AS Expr1 FROM PID_Street_names
b INNER JOIN PID_Streets c ON c.street_name_id = b.
street_name_id INNER JOIN PID_Address n ON
c.street_id = n.street_id INNER JOIN PID_Xref_Adr_Inf d ON
n.address_id = d.address_id WHERE (d.id = a.id)) AS
Str, a.* FROM PID_INFO1 a INNER JOIN
PID_Xref_Adr_Inf n ON a.id = n.id INNER JOIN PID_Address d
ON n.address_id = d.address_id Where d.atvk_id ='10000' and
d.street_id = '4532' ORDER BY Ter, Str, Liters
sorry for mess but this is how it is - everything glued in
single string variable
problem is that only first record in address row is listed
all rest goes blank
guys that write code say that they don't know what's worng
so can anybody please help? or perhaps give detailed
information on changes in access with sp1
tia
company that i work in use 'access' for db managment
they ordered programmers to develop system
and everything was fine until office sp1
there is form that list addresses and you have many options
to filter results
and particularly there is option to print
but first it generates report as i understand
form works right but report generated for print does not
however it worked before sp1 install and also on of2000
here is example of code passed to generate report:
SELECT DISTINCT a.id AS Expr1, (SELECT MIN(ISNULL(t1.
name + ', ', '') + ISNULL(t2.name + ', ', '') + ISNULL(t.
name + ', ', '') + t3.name) FROM
PID_Territories t1 RIGHT OUTER JOIN PID_Territories t2 ON
t1.atvk_id = t2.ref_atvk_id RIGHT OUTER JOIN
PID_Territories t ON t2.atvk_id = t.ref_atvk_id RIGHT
OUTER JOIN PID_Territories t3 ON t.atvk_id = t3.ref_atvk_id
INNER JOIN PID_Address n ON t3.atvk_id = n.atvk_id INNER
JOIN PID_Xref_Adr_Inf d ON n.address_id =
d.address_id WHERE (d.id = a.id)) AS Ter, (SELECT
MIN(isnull(b.street_name, '') + isnull(', ' + n.nr_num, '')
+ isnull(', ' + n.nr_char, '') + isnull(', '
+ n.home_name, '')) AS Expr1 FROM PID_Street_names
b INNER JOIN PID_Streets c ON c.street_name_id = b.
street_name_id INNER JOIN PID_Address n ON
c.street_id = n.street_id INNER JOIN PID_Xref_Adr_Inf d ON
n.address_id = d.address_id WHERE (d.id = a.id)) AS
Str, a.* FROM PID_INFO1 a INNER JOIN
PID_Xref_Adr_Inf n ON a.id = n.id INNER JOIN PID_Address d
ON n.address_id = d.address_id Where d.atvk_id ='10000' and
d.street_id = '4532' ORDER BY Ter, Str, Liters
sorry for mess but this is how it is - everything glued in
single string variable
problem is that only first record in address row is listed
all rest goes blank
guys that write code say that they don't know what's worng
so can anybody please help? or perhaps give detailed
information on changes in access with sp1
tia