I haven't programmed in Access for five years. The budget analyst asked me for help. Her report has page break after each group of organization. However, when
posting this report on e-print server(web), the page breaks are messed up. I would like to force a page break after every 55 lines. If there are 10 records per organization, I want to write extra 45 blank lines before the page break. If there is 65 records per organization, I want...
User Profile
Collapse
-
Page break after 65 lines - Access 2003
-
sqlplus exit statement prematurely terminates unix script
#!/bin/ksh
echo ""
echo "Enter person ID:"
read person_id
sqlplus -silent '/nolog'<<end_sql 1
connect useract/passwd
start $BANNER_LINKS/gurlsid.sql
$person_id
FAISMGR
end_sql1
cat person.lst >person_list
sqlplus -silent '/nolog'<<end_sql 2
connect useract/passwd
start $BANNER_LINKS/gurlsid.sql
$person_id
FIMSMGR... -
sqlplus exit statement prematurely terminates unix script
echo ""
echo "Enter person ID:"
read person_id
sqlplus -silent '/nolog'<<end_sql 1
connect useract/passwd
start $BANNER_LINKS/gurlsid.sql
$person_id
FAISMGR
end_sql1
cat person.lst >person_list
sqlplus -silent '/nolog'<<end_sql 2
connect useract/passwd
start $BANNER_LINKS/gurlsid.sql
$person_id
FIMSMGR
end_sql2...
No activity results to display
Show More