I have 2 tables in database with one-to-many relationship (actually one-to-two). I built crosstab query on the tables.
Now when I want to show the query in DBGrid I have a problem:I cannot defi...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_10249875.html
I have a table that I want to build a "crosstab" query from. MSAccess has this ability using the "PIVOT" command, but I need a standard SQL way of doing it (I am using Interbase SQL Server).
Th...
http://www.experts-exchange.com/Database/Miscellaneous/Q_10261066.html
Zones:
DatabasesDate Answered: 01/23/2000 Rating: 6.2 Views: 0
hello experts!
Can anybody help me on creating a crosstab query on SQL?I dont know if this is possible in SQL but in MS Access, it can be done. This is what i want to appear on the results:
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10354767.html
Zones:
MS SQL ServerDate Answered: 05/25/2000 Rating: 6.6 Views: 0
I have sales data in a table by customer.
I wish to produce a query that shows the data by month.
My date field is called [TransDate].
The problem is that the year needs to run from 1st...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_11972198.html
Zones:
MS AccessDate Answered: 11/25/2000 Rating: 7.4 Views: 0
I have a table containing date related data (e.g. a sales log). I can easily write a query that tells me all the sales that occured before a given date. I can write a crosstab query that shows ho...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20321838.html
Zones:
MS AccessDate Answered: 07/14/2002 Rating: 9.0 Views: 0
Access 97
I am trying to create a crosstab query that uses criteria specified from a combo box on a form. What I am doing is this.
I have created a report that is based off the Crosstab quer...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20487457.html
Zones:
MS AccessDate Answered: 02/03/2003 Rating: 8.6 Views: 0
I have two crosstab queries - Balance and Rate. Both of the queries contain Branch field (key). Balance query contains balances for the next 4 weeks (name of the columns are 1, 2, 3, 4) and Rate qu...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21116951.html
Zones:
MS AccessDate Answered: 09/03/2004 Rating: 8.2 Views: 0
Hi I am trying to do cross tab query for monthly production:
and my problem is that when I do monthly, I only want to do 2004, not 2003, it is calculating altogether.... how do I solve this?
...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Controls/Q_21198908....
Zones:
VB ControlsDate Answered: 11/10/2004 Rating: 7.6 Views: 0
Hi,
I'm using this sproc
http://www.sqlteam.com/item.asp?ItemID=2955
to make a crosstab query. It works very well, but is giving me too much data. The problem is that it generates a column for...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21331469.html
Zones:
MS SQL ServerDate Answered: 03/01/2005 Rating: 7.8 Views: 0
From this table:
AccountNo: Long
Date: Date/time
Pmt: Currency
I can create a crosstab query resulting in this:
AccountNo 01/03 02/03 03/03 04/03 ...
10...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21542793.html
Zones:
MS AccessDate Answered: 09/30/2005 Rating: 7.4 Views: 0
