Re: Crosstab with SQL Backend Problem
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Tue, 14 Oct 2008 13:27:39 -0400
pete.trudell@xxxxxxxxxxxxxxx wrote:
I really feel like the first man on Mars with this process-- No one
seems to understand Access 2007 and SQL, not even Microsoft has any
suggestions.
Whom have you talked to at Microsoft?
When I set-up the SQL Databse as the Back-end and Access 2007 as the
front end, the Query Grid changed to reflect a SQL Grid,
And you do not have a option to have a Crosstab Row.
And when you go to Microsoft to get help????? No Help. You Figure.
Again, when did you go to Microsoft for help?
Frustrated - Pete
Hmm, somebody must have led you to believe that programming for SQL
Server was the same as programming for Jet, with little or no learning
curve. Well, that's just not the case. No wonder you are frustrated.
I'm afraid I'm a little (lot) out of my depth here. If Access was not in
the picture, I could probably help since I program completely in SQL.
Here is an example of creating a pivot query in SQL 2005 (I'm not even
sure that is the version of SQL you are using ... ). It comes from SQL
Server Books OnLine (BOL) and I suggest you download a copy of it from
the microsoft website:
USE AdventureWorks
GO
SELECT VendorID, [164] AS Emp1, [198] AS Emp2, [223] AS Emp3, [231] AS
Emp4, [233] AS Emp5
FROM
(SELECT PurchaseOrderID, EmployeeID, VendorID
FROM Purchasing.PurchaseOrderHeader) p
PIVOT
(
COUNT (PurchaseOrderID)
FOR EmployeeID IN
( [164], [198], [223], [231], [233] )
) AS pvt
ORDER BY VendorID;
Here is a google search result that provides more explanations about
using pivot:
http://www.google.com/search?q=pivot+operator+t-sql&rls=com.microsoft:en-us:IE-SearchBox&ie=UTF-8&oe=UTF-8&sourceid=ie7
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- Follow-Ups:
- Re: Crosstab with SQL Backend Problem
- From: pete . trudell
- Re: Crosstab with SQL Backend Problem
- References:
- Crosstab with SQL Backend Problem
- From: pete . trudell
- Re: Crosstab with SQL Backend Problem
- From: Lord Kelvan
- Re: Crosstab with SQL Backend Problem
- From: pete . trudell
- Re: Crosstab with SQL Backend Problem
- From: Bob Barrows [MVP]
- Re: Crosstab with SQL Backend Problem
- From: pete . trudell
- Re: Crosstab with SQL Backend Problem
- From: Bob Barrows [MVP]
- Re: Crosstab with SQL Backend Problem
- From: pete . trudell
- Crosstab with SQL Backend Problem
- Prev by Date: Re: Same Field, Multiple Criteria
- Next by Date: RE: How to query a field for Absolute Value in Access 2007
- Previous by thread: Re: Crosstab with SQL Backend Problem
- Next by thread: Re: Crosstab with SQL Backend Problem
- Index(es):
Relevant Pages
|
