Help to write a report

2004-11-12 Thread Laercio Xisto Braga Cavalcanti
Hi all again, I´m sending my question attached in a .txt file and maybe it will be a little bit easy to understand. Regards, Laercio Xisto Braga Cavalcanti Endless Technology Sistemas de Informação Rua Peixoto Gomide 321 Cerqueira César São Paulo SP CEP: 01409-001 Fone: +5511-3255-3430 ma

Help to write a report

2004-11-12 Thread Laercio Xisto Braga Cavalcanti
Hi all, I have the following select: select cons_nome as "Consultorio", dent_nome as "Dentista", pac_nome as "Paciente", pac_convenio as "Tipo", Pac_matricula as "Matricula", concat(consulta_dia, "/", consulta_mes, "/", consulta_ano) as "Data", concat(Consulta_hora, ":", consulta_mi