Re: getting more rows out of a table

What you mean by: "I can get the information on the screen using a FOR statement in the FORMAT section, but then I can't do the calculations." Why can't you do the calculations? It thing you almost have it. J. gingerafro escribi': > I currently have a table showing data for hotels with fields such as: > day_no > start_date > nights > > Now, the table does not list every night stayed, just the checkin and > number of nights stayed. > I need to show every day in a report, and also do some calculations on > it. I can get the information on the screen using a FOR statement in > the FORMAT section, but then I can't do the calculations. > > Can I use a FOR statement in SELECT? If so, how. Or if not, got any > smart ideas??? > > sending to informix-list