adding columns to crosstab queries

G

grantschneider

I have a very simple crosstab query and I am trying to create a new
column thatr divides uses the following expression: [Total of Share
Total]/[Share Total]

My code:
TRANSFORM Sum(MSF07.[Share Total]) AS [SumOfShare Total]
SELECT MSF07.Aircraft, Sum(MSF07.[Share Total]) AS [Total Of Share
Total]
FROM MSF07
GROUP BY MSF07.Aircraft
PIVOT Format([Date Closed],"mmm") In
("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");


I am also having trouble with the date fields. I want the columns to
show up as Jan Feb.. etc. but I also want to prompt for a between
[month] and [month]. I have all the formats as date/time but when i
type in JAN through JUL it gives me the months which fall
alphabetically between JAN and JUL.

Thanks
Grant
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding column totals to crosstab queries in ACCESS 2003 1
parameters and crosstab queries 2
How to getting text labels to show up in scatter chart. 0
Crosstab qry not adding up 1
Group by Range in Crosstab Query 5
UNION and Crosstab query 5
Crosstab returns blank fields 6
Date order in a crosstab query 2

Top