Re: ACE Report [?]

Max, There are a FEW of us dinasaurs left here. If memory serves, you really can't do this cleanly; the report's select statement is compiled (and hence, set) when you compile the report. If you don't mind a somewhat ugly hack, you could either have a script call one of N reports (where N is the number of tables that could be called, and each script uses a different table). If you don't mind a REALLY ugly kludge, you could even create a script recompile the report each time with the appropriate table name in it. (You! Over there! Put down that rotten tomatoe; I SAID it was ugly! ;-) David }Greetings! } }I realize that ACE reports aren't terribly sexy, but I }DO have to work with one. To that effect, would someone }be so kind as to help me here? } }I need to prompt a user for a tablename. That tablename }needs to be passed to the select statement. } }If someone can offer guidance in this regard, I'd }appreciate it a great deal. } }thanks!!! } }Max }pyz@panix.com