Ask a Question related to ASP Database, Design and Development.
-
melody #1
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 four
or so) and then join them together.
Just wondering if there is a way to simplify this.
Thanks in advance,
melody
melody Guest
-
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... -
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... -
CAML Query: Multiple Query Fields Issue
I need to Create a CAML Query Dynamically with VB to a Sharepoint WebService GetListItems Method. The User Could Select 1 to X Number of IDs... -
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... -
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... -
melody #2 Crosstab query with multiple value fields
Oops, posted in the wrong newsgroup by mistake...
value>-----Original Message-----
>Hi again,
>
>Is it possible for a crosstab query to have multiple>fields ?
>The way I'm working now is to create separate crosstabs
>(about four
>or so) and then join them together.
>
>Just wondering if there is a way to simplify this.
>
>Thanks in advance,
>melody
>.
>melody 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
