Go Back   Access World Forums > Search Forums

 
Showing results 1 to 5 of 5
Search took 0.01 seconds.
Search: Posts Made By: kevisull
Forum: Queries 12-03-2008, 07:55 AM
Replies: 8
Views: 4,952
Posted By kevisull
Re: Crosstab Query Column Headings

ok diff question.

I have the below query and everytime i change it to Ascending in the design view not the code view Access encounters an error and must close. can you help me rewrite the code...
Forum: Queries 12-03-2008, 05:23 AM
Replies: 8
Views: 4,952
Posted By kevisull
Re: Crosstab Query Column Headings

here is the current code if you can adjust it to work i can paste it in but that is my extent of doing code :(

TRANSFORM Sum(tbl_DB_Supply_Demand_Reporting.HOURS) AS SumOfHOURS
SELECT...
Forum: Queries 12-03-2008, 04:24 AM
Replies: 8
Views: 4,952
Posted By kevisull
Re: Crosstab Query Column Headings

So I am still a little confused on the Iff statement in the Column Heading property. I know where the statement should go but can you help me understand how to write it.

So in the...
Forum: Queries 12-02-2008, 04:31 PM
Replies: 8
Views: 4,952
Posted By kevisull
Re: Crosstab Query Column Headings

I do not understand code. Should I add something to the query properties column headings?
Forum: Queries 12-02-2008, 01:47 PM
Replies: 8
Views: 4,952
Posted By kevisull
Crosstab Query Column Headings

I have a crosstab query with 6 row heading fields and then the field [FTE_DATE_YM] as the column heading and the field [Hours] as value which is a sum. The FTE_DATE_YM field is a series of 12 months...
Showing results 1 to 5 of 5

 
Forum Jump



All times are GMT -8. The time now is 10:40 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World