Ask a Question related to Coldfusion Database Access, Design and Development.
-
PrinBD #1
Crosstab Query Export
I have a crosstab query which i want to export, using a Macro, as an excel
sheet to a specific folder (using TransferSpreadsheet or TransferText options
in the Macro). Any ideas on how i fill in the required fields? keep getting the
error "Cannot update: database or object is READ ONLY".
I have it working perfectly for Make table queries (using
TransferSpreadsheet)and it emails me the link when the macro completes. I just
want to add this crosstab query to the Macro so that it also exports.
Any help would be greatly appreciated!
PrinBD Guest
-
Crosstab Query with Date Fields
Pulling my hair out! Ok here's what I got: I need to output 2 queries with 2 different datefields with different Years (2 max) in tabular format... -
Crosstab query with multiple value fields
Hi again, Is it possible for a crosstab query to have multiple value fields ? The way I'm working now is to create separate crosstabs (about... -
Crosstab query - Nearly there!
Try: select a.status, (select count(*) from #crosstab where tsize = 20 and status =a.status) , (select count(*) from #crosstab where tsize = 40... -
recreating a crosstab query - explanation of an example requested
Try this correlated subquery: Select distinct status, 10=(Select Count(MovementNo) from BigTable where size=10 AND status=Big.status),... -
No true Crosstab Query in Oracle???
Gavin John Fowler wrote: Cross-tabulation is easily accomplished using DECODE and CASE. Just alias the resulting columns. To handle an... -
philh #2 Re: Crosstab Query Export
Hi PrinBD,
Cut and paste your entire question into an Access forum somewhere. Start with [url]http://msdn.microsoft.com/newsgroups/managed/[/url].
Are you trying do effect this action through ColdFusion?
philh Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
