by: ricksql |
last post by:
#temptable (studentID,p/f,examid,examname):
1 p
2 f 100 bio
2 f 101 mTH
2 f 102 CHM
2 f 103 spts
2 f 104 LIT
2 f 107 geo
2 f 109 phys
2 f 110...
|
by: Thomas R. Hummel |
last post by:
Hi,
I was just helping a coworker optimize a query. He had two versions:
one which used UNION for each value for which he was tallying results
and another query which used GROUP BY. Here is an...
|
by: techquest |
last post by:
got slightly similar table.
#Temp Table:
name,name1,name2,exam,score
A,A1,A21,
A,A1,A21,math100,88
A,A1,A21,math101,56
A,A1,A21,
A,A1,A21,math102,67
A,A1,A21,
A,A1,A21,math104,45
|
by: RBohannon |
last post by:
I'm using Access 2000 on Windows 2000.
I have a DB of several exams and people who have taken them. I need
to assign ranks to the people according to their scores (within each
exam).
I have...
|
by: RBohannon |
last post by:
I have a report with most fields populated by a query. However, some
of the fields are variable in such a way that their values cannot be
queried from a table. At present the values for these...
|
by: RBohannon |
last post by:
I'm using A2K.
I would like to create a form that would allow the user to run a
particular query by entering the parameters into one or more text
boxes.
I am currently using a parameterized...
|
by: RBohannon |
last post by:
I'm using Access 2000.
I currently have a report being generated using the results of a query
by form. The form used for this query is an unbound form,
frmListDialog. frmListDialog contains...
|
by: Marc DVer |
last post by:
As a simple example, say there is table 'namelist' with column 'names'
as char(20). I would like to do something akin to:
select namelist.names as mynames, left(mynames,2) as initials;
In...
|
by: MLH |
last post by:
I have a query with a single table. One of the table fields appearing
in the QBE grid is containing values from 1 to 127.
Then I have the following calculated field named :
Published: IIf((1...
|
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
|
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...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|