A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Use crosstab column heading in a calculation



 
 
Thread Tools Display Modes
  #31  
Old January 20th, 2006, 07:36 PM posted to microsoft.public.access.queries
external usenet poster
 
Posts: n/a
Default Use crosstab column heading in a calculation

The crosstab query delivers a variable # of fields. I won't know in advance
how many fields or what their names will be. As long as I have to write code
anyway, I may as well do the whole operation in a VBA procedure, which is
what I've decided to do.
It is indeed unfortunate that Duane's simple form would be a perfect solution,
if only it could work for a crosstab query of indeterminate fields.

That's showbiz!

Vincent Johns wrote:
So, why don't you just specify which columns you want?

In Query Design View, right click in the upper window and set the Column
Headings property to something like

1,2,23

or whatever you want displayed there.

Or, you could place a filter on the Crosstab Query by specifying a
criterion (such as

69

) on the Column Heading field in Query Design View.

Alternatively, you could define another Select Query that uses your
Crosstab Query as its data source and select only the fields (via a
criterion in your Select Query) that you want to use. Don't expect the
results of the Select Query to be modifiable, though.

-- Vincent Johns
Please feel free to quote anything I say here.

When I open the form I get the msg:

[quoted text clipped - 18 lines]

Bill


--
Bill Reed

"If you can't laugh at yoursel, laugh at somebody else"

Message posted via http://www.accessmonster.com
  #32  
Old January 21st, 2006, 05:14 AM posted to microsoft.public.access.queries
external usenet poster
 
Posts: n/a
Default Use crosstab column heading in a calculation

OK, I wasn't thinking that you actually WANTED to have a variable number
of fields, as apparently you do. But are you sure your users want to
see data displayed like that? They would have difficulty, I expect,
navigating 120-130 fields on a subform. (Or at least I think I would.)
I don't know, of course, since I'm not familiar with your application,
but my guess is that if you can find a way to choose convenient subsets
of, say, a dozen or so related fields at a time for users to deal with,
it might be easier for them to use your system.

-- Vincent Johns
Please feel free to quote anything I say here.


Bill R via AccessMonster.com wrote:
The crosstab query delivers a variable # of fields. I won't know in advance
how many fields or what their names will be. As long as I have to write code
anyway, I may as well do the whole operation in a VBA procedure, which is
what I've decided to do.
It is indeed unfortunate that Duane's simple form would be a perfect solution,
if only it could work for a crosstab query of indeterminate fields.

That's showbiz!

Vincent Johns wrote:

So, why don't you just specify which columns you want?

In Query Design View, right click in the upper window and set the Column
Headings property to something like

1,2,23

or whatever you want displayed there.

Or, you could place a filter on the Crosstab Query by specifying a
criterion (such as

69

) on the Column Heading field in Query Design View.

Alternatively, you could define another Select Query that uses your
Crosstab Query as its data source and select only the fields (via a
criterion in your Select Query) that you want to use. Don't expect the
results of the Select Query to be modifiable, though.

-- Vincent Johns
Please feel free to quote anything I say here.


When I open the form I get the msg:


[quoted text clipped - 18 lines]

Bill

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to Improve Code Copying/Pasting Between Workbooks David General Discussion 1 January 6th, 2006 04:56 AM
creating a bar graph Johnfli General Discussion 0 October 26th, 2005 08:16 PM
Crosstab Column Heading Sort MJatAflac Running & Setting Up Queries 3 June 29th, 2005 01:54 AM
How do I set up a report using dates as my report header? Robin Setting Up & Running Reports 16 November 13th, 2004 02:00 PM
Using Validation to force entry into cells? Mark General Discussion 16 October 27th, 2004 09:23 PM


All times are GMT +1. The time now is 11:17 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.