473,382 Members | 1,329 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Crosstabs queries again?

Ray
I have developed a school db in which I need to assign teachers to
classrooms. Some schools number their classrooms 1,2,3, etc or maybe
1A, 2A, 3A etc or even 101, 102, 103 etc. It's up to them as to how
they do it. I just have to live with it.

I can design a crosstab query to show the classes etc for the various
naming conventions for each school however is there a way to
programatically set the fields in a subsequent form based on the
crosstab? I can't used the heading column in the crosstab query as
that can change depending upon the school's naming system.

Any help greatly appreciated

Thanks - Ray
Nov 12 '05 #1
0 1048

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: RCS | last post by:
I have a crystal report which works fine in the Crystal design. The crosstabs display the summarized fields as horizontal, but when I run the same report in dotnet the crosstabs display the...
2
by: John Baker | last post by:
Hi: While the crosstabs capability appears very powerful, I don't see how I can get the information into a form or anything else. Is there some way I can do a cross tabs, and then use the...
9
by: Dom Boyce | last post by:
Hi First up, I am using MS Access 2002. I have a database which records analyst rating changes for a list of companies on a daily basis. Unfortunately, the database has been set up (by my...
2
by: Cassie Pennington | last post by:
I am using VBA to determine which query sits behind a report, depending upon the preferred sort order. This has worked perfectly for ordinary select queries behind reports, but it seems to be...
3
by: Ian Roddis | last post by:
Hello, I want to embed SQL type queries within an XML data record. The XML looks something like this: <DISPLAYPAGE> <FIELD NAME="SERVER" TYPE="DROPDOWN"> <OPTION>1<OPTION> <OPTION>2<OPTION>...
3
by: Emily Jones | last post by:
This: TRANSFORM First(.Text) AS FirstOfText SELECT .Expr1000 FROM _allText GROUP BY .Expr1000 PIVOT .LetterSectionID; hangs the application if _allText.Text is a memo field. But it's fine...
2
by: Donna A | last post by:
Hello, I am using Access 2000. The data in my database is normalized, with a column for the month and then a column for the data. In order to display this, I have to run a crosstab to put the...
1
by: JosAH | last post by:
Greetings, Introduction This week we start building Query objects. A query can retrieve portions of text from a Library. I don't want users to build queries by themselves, because users make...
5
by: marshmallowww | last post by:
I have an Access 2000 mde application which uses ADO and pass through queries to communicate with SQL Server 7, 2000 or 2005. Some of my customers, especially those with SQL Server 2005, have had...
0
lotus18
by: lotus18 | last post by:
Hello World! I have 2 crosstabs on my crystal report. My crosstabs are using only one table. But, I want my second crosstab to retrieve only distinct values. Is this possible? If not, my other...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.