M
MichaelAngelo
Hi there,
I have a report that relies on a query called polereport this query is based
on 6 tables and the criteria is to enter a valid job number in order to
produce the report
..I have included a such report that lists one field called att_type.this
field is from the att table and is also part of the polereport query.My
problem is that when I run the report I am prompted 5 or 6 times to enter the
job number before the report is printed.Can anyone know what the problem
could be?There is NO problem with the query.
Another problem is that I need to have 1 detail section for 2 tables Pole
and Cross arm and attachment type.
as follows
Pole Number, Owner Cross arm material -Header section
eg
57869 Centron
Cross arm level - detail
eg
1
2
Att type sub report
eg
sock
stay
I would like the report to appear as shown but what I have is
1
sock
2
stay
How do I prevent them from overlapping and keep them in a list?
-
Much help appreciated thank you so much for your ideas
I have a report that relies on a query called polereport this query is based
on 6 tables and the criteria is to enter a valid job number in order to
produce the report
..I have included a such report that lists one field called att_type.this
field is from the att table and is also part of the polereport query.My
problem is that when I run the report I am prompted 5 or 6 times to enter the
job number before the report is printed.Can anyone know what the problem
could be?There is NO problem with the query.
Another problem is that I need to have 1 detail section for 2 tables Pole
and Cross arm and attachment type.
as follows
Pole Number, Owner Cross arm material -Header section
eg
57869 Centron
Cross arm level - detail
eg
1
2
Att type sub report
eg
sock
stay
I would like the report to appear as shown but what I have is
1
sock
2
stay
How do I prevent them from overlapping and keep them in a list?
-
Much help appreciated thank you so much for your ideas