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. |
|
|
Thread Tools | Display Modes |
#31
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |