473,396 Members | 1,683 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,396 software developers and data experts.

Similar ranking in same CGPA for ms access database (front end vb6.0)

1
Expand|Select|Wrap|Line Numbers
  1. RANKING SIMILAR ITEMS
  2.     cmd1 = "SELECT CGPA_III FROM t_PG_Rank"
  3.     rs1.Open cmd1, conn, adOpenStatic
  4.     While Not rs1.EOF
  5.         cnt = get_Number("SELECT COUNT(*) FROM t_PG_Rank WHERE CGPA_III = " & rs1.Fields(0))
  6.  
  7.         If cnt >= 1 Then
  8.             i = get_String("SELECT MIN(rank) FROM t_PG_Rank WHERE CGPA_III =" & rs1.Fields(0))
  9.             cmd = "UPDATE t_PG_rank SET rank = '" & i & "' WHERE CGPA_III = " & rs1.Fields(0)
  10.             Call insert_data(cmd)
reply is quickly
thank you

how to calculate similar ranking in msaccess table
Aug 6 '14 #1
2 811
zmbd
5,501 Expert Mod 4TB
Ranking Queries in MS Access SQL

Our Insights Articles range from the most basic information, often needed/performed tasks, to some very complex and esoteric aspects of Access. I Highly recommend taking a look thru them... I also prefer the list view for these articles: Microsoft Access / VBA Insights Sitemap
Aug 6 '14 #2
NeoPa
32,556 Expert Mod 16PB
I would have deleted the question except for the reply which may prove helpful.
Aug 6 '14 #3

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

Similar topics

7
by: Graham Taylor | last post by:
I've tried posting this in the 'microsoft.public.access' but I will post it here also, as I think it might be the webserver which is causing my problem. --------- I have an Access 2003 database...
5
by: Scott Drane | last post by:
I'm somewhat of a newbie at this, and a bit overwhelmed at all the information (ODBC, ASP, VB, etc). I'm doing a little work on Access for a small company, and someone had the brainstorm that we...
1
by: Ren | last post by:
I have set up an access database with a switchboard to multiple forms, reports, etc. I have gotten comflicting information about whether or not staff throughout my facility will be able to view...
49
by: Yannick Turgeon | last post by:
Hello, We are in the process of examining our current main application. We have to do some major changes and, in the process, are questionning/validating the use of MS Access as front-end. The...
5
by: premmehrotra | last post by:
I currently have a multi-user access database which is put on a shared drive L: on a Windows Servers. Entire database is one file premdb.mdb. Users access this database from their laptops....
2
by: James | last post by:
Dear Access Guru's, Hopefully you can help me (as Microsoft don't seem to be able to) We have an Access database on a Windows 2003 server with 5 CALS in our office. Access is loaded onto...
3
by: Frank | last post by:
We have an Access database Sch_S.mdb in the shared driver S across the network. I have a copy of that database in my local driver C, named as Sch_C.mdb. As per users' request I added some check...
18
by: surfrat_ | last post by:
Hi, I am having the following problems in getting Microsoft Visual Studio 2005 Professional to link to an Access .mdb database. Please help me to sort this out. Problem 1: The Microsoft...
1
by: saifulislam | last post by:
Hi All, i m a network administrator in a multinational firm. i m facing a problem while accessing an access databse file in the LAN. We have our database file where different employees make...
1
by: fred gratz | last post by:
I am using ODBC socket server to connect to a remote MS Access database. It does have table employee and timecard. When i send a query to employee table it successfully returned values by when I...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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...
0
marktang
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,...
0
Oralloy
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
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 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.