Bill Taggart

Ralph please check me out on this. I belive your answer to island_tony re his 3 page spreadsheet also answers my question. I have a multiple column report that I want to display in landscape mode. However I have 43 columns that I want to display for each record (one for each time period). Since that won't fit on one page, I loose all columns after the first page unless I "constrain to page width" in the "New Layout" window. Since that wraps the columns that won't fit on the first page, I will get multiple lines for the same record. That makes scanning one field at a time across records difficult (confusing). I want a layout with a single line for each record from left to right for as many pages as needed to display 43 fields. Is your advice to island_tony to create as many layouts as needed for the pages to the right of the first the only way to do this?

RalphL - ELEGANT! - Thanks, Bill

Thanks to Barbecue and RalphL. Your suggestions put me on the right track. But I'm still a bit stumped. I found the function for converting Time to seconds (Seconds) and the function for reversing the process of converting total Seconds into a TimeStamp (GetAsTimestamp). To complete the process of converting from a TimeStamp to seconds, is there a function that wasn't obvious to my searching eye for converting a Date to seconds? With the latter unknown third function, I would take the TimeStamp givens in my calculation (DT Request and DT First); 1. Convert their Time (Seconds) and Date into total seconds, 2. Use that result to calculate the difference in equivalent seconds, 3. Finally convert that difference back into a TimeStamp (GetAsTimestamp). Is there a function for converting a Date to seconds? If not what is a recommended work around? Thanks again, Bill

This is my initial post as a Novice. I'm using a FM (7.0) database of parsed server access logs to study visitor usage patterns to my site (www.the-intuitive-self.org). I've used FM on a modest scale for simple off-line databases. Now I'm tackling ScriptMaker for the first time. I've got my first script up and running (after many false starts) with one exception. I'm trying to calculate an elapsed visit time (DT Visit) using TimeStamp variables to represent the date and time of the most recent request (DT Request) and the first request (DT First) in a visitor session, e.g.; DT Visit = DT Request - DT First where all variables are defined as TimeStamp and stored in the format; 11/10/2004 20:50:46. The calculation appears to work as long as "DT Request" and "DT First" are no more than 24 hours apart even when they are on consecutive days, e.g.; 01/02/2004 00:35:57 - 01/01/2004 23:35:03 successfully yields 1/1/0001 1:00:54. However; 11/10/2004 20:50:46 - 11/05/2004 23:29:47 yields "?" which I assume means undefined. I expect the result to be approximately 1/5/0001 23:35:25, i.e. 4 days, 23 hours, etc. The references I've checked haven't shed light on the problem. Any guidance will be appreciated. Thanks, Bill