Re: Creating a report from 3 tables

From: elizabeth1000@my-deja.com > > > > > What's so hard or did you not tell us something? > >well maybe I'm being really stupid but while I can get the data out >interactively this way, I'm having trouble loading it into another >table or formatting it report fashion. The PM needs to run this report >interactively whenever he wants so I was going to put it into a unix >script. > >I'd really like an after insert trigger on the main table when >completed goes to not null it updates my holding table and I generate a >report from it. > >I very much appreciate your help and if I'm being dense please excuse. Aaahhhh...clarity... SQL*Plus's formatting capabilities have no direct equivalent in dbaccess. Maybe you could download JL's excellent sqlcmd, which may offer better facilities, or you might have to resort to an Ace report. HTH. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com