Need Help To Calculate A Running GPA In Access!

Apr 25, 2006

Hello, I have volunteered to do a database for the school of nursing to use at a small Christian University using Microsoft Access 2003. I have Students, and each of these students is going to take each of these 12 nursing courses. Each nursing course has a specific number of credit hours (2,3,6, etc.) and they are to receive a grade for each class (on a 4 point scale, so their grades are going to be a number 0 for F through 4 for an A). I need to have access calculate a running GPA which only takes into consideration the classes they have completed thus far. Any help would be appreciated. I can do it in excel by just leaving the row for untaken courses blank, then autosumming the credit hours column for total hours taken. I can use a formula for each row that just multiplies the grade (like 4.0) by the credit hours (like 3) and get a total grade points of 12 for that course. Then I can add those numbers up(autosum the total grade points column) and devide by the calculated autosum number I would call total hours. I hope it is clear what I am trying to do and why I don't know how to do it in Access. ***************Extra Info*********
I have a student table and each student has a unique studentID, I have a second table called Nursing grades which I have a Student ID field, and 2 fields for each class a grade recieved and a credit hours field (ex. I have PharmacologyGR and PharmacologyCH, NursingResearchGR and NursingResearchCH). If I need to redesign how I have my tables I can do that, I have a unique Course ID for each course I could put in if needed. Basically, I'll do whatever it takes to get this to work.
Thank you so much for even reading this far, and any help would be appreciated more than you know.

View Replies


ADVERTISEMENT

Queries :: Running Total To Calculate Uptime Monthly

Jul 1, 2013

I am having trouble with this running total. Let's say I have a well. I am trying to create a running total that calculates the total Uptime (or hours operational) for each well every month.

I attached a PDF with an example of what I am working with.

View 10 Replies View Related

Queries :: Self-Referencing Running Total Used To Calculate Next Total In A Query

Jul 23, 2015

I am trying to create a query that has a self referencing running total based on the values (point totals) of itself (running total of values in the running total column that have already been calculated for all previous records) plus the total of new points being added in the current record, less the total of points being removed in the current record. This running total can never go below 0, if it does, the running total should restart at zero and add in only new points and begin the process again with the next records

I am able to do this in Excel in less than two seconds so I know there has to be a way to port this into a query. I've attached an excel example of what I am exactly trying to do

If it takes multiple queries to complete the required output I am ok with it. In my previous outtakes I have had up to 8 queries but just couldn't seem to do it..

View 9 Replies View Related

General :: Only Open MS Access Form Without Access Running In Background?

Aug 7, 2013

I have made a form on access which will be used by other employees within the company, however they have never used access before and they are wanting to access only just the form as I feel with Access and all the tools in the background will confuse them, plus I don't want them editing the data base its self.

Is there a way to only bring up the form, unless I obviously need to edit the date base.

I've done some research on Google and it seems I need to use:

SW_SHOWMINNOACTIVE

However I can not seem to find how I would use this or where?

and also if i did find a way to only bring up the form, how would I be able to switch it from that veiw to the veiw I edit in?

View 2 Replies View Related

Problem Running Access 2007 And Access 2002

Mar 27, 2007

Having a problem here after installing 2007. All my previously created databases work fine in 2007 (after clicking the enable, which is a pain,but don't know any other way) When I return to 2002 and try to open the databases I get different errors all something like this on....... "The expression On Open you entered as the event property setting produced the following error: Object or class does not support the set of events. Whats up here?????I have found a site here...http://allenbrowne.com/bug-17.htmlMentions this problem,but refers to Vista..... Does the same apply to XP? And which is the best fix?

View 7 Replies View Related

DB Closes But Access Keeps Running!

Feb 10, 2006

I run several databases daily - after running two of them (at different times), the database itself closes but the Access program stays open. In order to close that program, I have to close it out using the Task Manager.

Any suggested solutions? Thanks (as always) for your assistance.

Bob

:confused:

View 1 Replies View Related

Running Access 2.0 Application

Jul 20, 2006

Hello,

I have an Access application which was written on Access 2.0. I need to run it (as is). I saw that it was possible to run it using some kind of Access 2.0 runtime environment - my client uses the following command to run the application:

Msarn200.exe application.mdb /ini application.ini

Where can I get this MSARN200? Do I have to find the Access 2.0 installation itself?

View 5 Replies View Related

Running Reminders Through Access

Aug 23, 2007

Is there anyway to use Access to run reminders?

I am trying to figure out the easiest way to have a reminder pop-up to run a letter for specific reps that would happen every 3 months.

Thanks for any help on this.

View 1 Replies View Related

Running Count In Access

May 17, 2007

I am trying to count records in a running sum fashion in a QUERY and for the records to restart when the field changes. I tried DCount without success.

ie. if a field contained the following data
Code Running Count
C101 1
C101 2
C103 1
C103 2
C103 3
C104 1
C104 2

Thanks

View 1 Replies View Related

Running .bat Files From Access

Mar 1, 2007

Anyone know how to run a bat file from Access.

This is what I am trying....I see the DOS window pop up and then its gone...the .bat does not appear to be running.

Call Shell(Environ$("COMSPEC") & " /c F:BAT_File_Storagedir_list.bat", vbNormalFocus)


ADDITIONALLY I want to replace "F:BAT_File_Storagedir_list.bat" with variable. What woudl be the correct syntax for that?


.

View 3 Replies View Related

Access 07 Running 03 File

Aug 21, 2007

does anyone ever have problems with constant crashing. it just crashes for no reason, i'll just start typing some code then CRASH. i'm all up to date according to mircosoft.
i'm running vista/office07/accessfile00-03

View 1 Replies View Related

No VBA Modules In Access DB Running On OSX

Jan 7, 2013

I have just installed the windows version of Access 2010 on OSX Mountain Lion using a program called Crossover which works very similarly to WINE. I have found that Access will install fine except for VBA form modules and BAS modules, although there seems to be no indication that they did not install as the entire install progresses fine.

I've put together an invoicing program that was created in Access 2010 in Windows but have transferred it over to Access 2010 installed on OSX. It contains a number of forms with code but when I go to VBE, form code modules are not visible. When I try to view the code for a form I get the following error message: "Microsoft Access failed to create the Visual Basic module. If your database is on a network drive, check your network connection, then try again". I was able to insert a BAS module and create a rudimentary VBA subroutine which ran without error so it does seem able to interpret VBA as per normal.

View 2 Replies View Related

Access 2003 Running Very Slow

Jan 31, 2006

I have access 2003 installed on two different machines. One machine was built 6 months ago with the best hardware available. The other was an older slow IBM.

For some reason, I am experiencing what appears to be some serious time delay (talking in the range of seconds, sometimes tens of seconds) when building a report that has a subreport in it on the fast machine. Yet when I load the exact same database on the slow machine, the report opens instantly.

Any ideas? I'm lost.

View 3 Replies View Related

Running Access Against Multiple Databases - DEV/UAT/PRD

Feb 21, 2007

Access 2003

I've inherited an Access Application which has
(1) a number of linked tables that are used to seed the underlying SQL Server database.

This system has been set up and is working in Development. My task is to move it to UAT but with regards to point (1) above I can't see any alternative but to copy the Access Database, create a new System DSN and re-import the External Data from the new DSN. What I'd like to do is use the same Access Database to point towards DEV or UAT or PRD. Is this possible to do this or am I stuck with maintaining 3 different Access Databases ?

I am a developer with many years of experience but my Access knowledge is limited so any pointers would be helpful.

View 5 Replies View Related

Running Queries In Access 2003

Jan 6, 2006

Not sure what happens.

occassionally i will run queries that have run before,
the hourglass will turn on, then turn off, and access does nothing
visible, but tack manager says its running 90% cpu. . .

any ideas on what is happening or i am doing wrong?

thanks

sportsguy

View 5 Replies View Related

Running Query In Excel On Access

Aug 3, 2007

Am running a query in Excel on an access table that uses lookup columns. The query is returning in excel with the right data but is returning the lookup value number rather than the data stored inside. How can I return the actual data value rather than the lookup value number.

i.e I have a list of areas

NY
CT
WA

in a lookup column.

User selects CT so is lookup value 2. But I want excel query to return CT.

How can I do this?

thanks

View 2 Replies View Related

Running Copy Paste Outside Of Access

Mar 30, 2005

CAn i change the name of a field in a a folder from access. or better yet can i automate a file being copyed from one folder to another.

For example, lets say i have a folder named photo. i want access to find all the items that finish with a "f" and copy them into a new folder named "f_Photos"

Any Help

View 4 Replies View Related

Running An Excel Macro From Access

Jun 14, 2004

Hi all,

I was hoping that someone could tell me if it is possible to run an Excel macro from an Access database. I am importing 3 Excel worksheets into Access and this macro needs to be run on all 3 evertime that this file is imported by the user (twice a week). If this can be done could someone please tell me how ??

View 14 Replies View Related

Running Access For Multiple Users

Sep 8, 2011

I have an MS Access application for about 40 users. The problem is that the company does not want to have to buy all these licenses and put it on each machine. Also because each person had to bring in their own set of data multiple people cannot be hitting this at once. So they want to know if there is a way to allow the people to use it without having the application on their machine; and thereby saving the money of buying 40 licenses.

View 2 Replies View Related

Running Balance As Opposed To Running Total

Mar 14, 2005

Can anyone tell me how to get a running balance on a report. I know how to create a running total, by setting the "running sum" property of a text box to "Over all".

I can't however see how I can adapt this to give a running balance (as in a bank statement for example). Attempts to do so end up in failure!!

Many thanks in advance.
Peter

View 2 Replies View Related

Calculate Percentage On Access Form

May 4, 2006

Hi, Thanks in advance. I am trying to calculate percentage, it has to round to the nearest, and also if the percentage is greater than 100 then it has to write 100%.
formulae: c=(a/b)*100,
example: c=(8/3)*100 =266.66% but this is more than 100% so i need this as 100%
example2: c=(2/3)8100=66.66% but i need it to round as 67%

i've 3 controls on a form a,b,c. so c has to calculate by itself when they enter data on a and b.
thanks,
sam

View 1 Replies View Related

Is It Possible To Use Access Calculate Freight Costs

Nov 24, 2007

I need to audit the freight bills charged by freight company which has over 20,000 consignment per week. The basic charge is base on distance and weight, something like this:
SYD-MEL <1kg $6
SYD-MEL<3kg $6.7
SYD-MEL<5kg $7
SYD-MEL<10kg$10
SYD-MEL>=10kg $12, $4 per kg rate
SYD-PER<1kg $10
.....

Based on the freight rate, how can I use Access to calculate the freight charge for each of the consignment ? Is there anyway to build some query or something to retrieve the freight rate and calculate the freight cost of each consignment?

Thanks

View 10 Replies View Related

Need To Calculate Quantity With Price In Access

Mar 25, 2013

I need to calculate qty with price in a form.

View 14 Replies View Related

Cut/Paste When Application Running Using Access Runtime.

Mar 23, 2006

Hi all..

I have access 2003 and I package my application with Access runtime. Users do not have access installed in their computers.

The problem the users have is, they cannot Copy/Cut/Paste from the textbox controls in the application..The same application when I run using my full version of Access 2003, I can cut/paste...

Is there a way to fix it without having to get full version of access ? or I have to live with it because I use access runtime.

Thanks

View 5 Replies View Related

Problem Running Access 2000 MDE On Vista

Feb 16, 2007

Hi there - hopefully someone can help me out, as we've got clients waiting on my response to this problem!!! :eek:

Anyway, my company produces an Access 2000 MDE which we ship with the Access 2000 runtime (just in case our clients don't have full Access installed)

We've had a number of calls saying that our app doesn't run on Vista, and the error provided points towards a reference problem. However, when I load the MDB on Vista using Access 2007, there are no reference issues.

Is this problem related to Access 2007 reference ("Microsoft Access 12.0 Object Library") somehow being used instead of the Access 2000 one? ("Microsoft Access 9.0 Object Library") - I am about to try uninstalling Access 2007 and running the app again to see if that helps...?

Any help greatly appreciated!

Baz

View 1 Replies View Related

Why Is Access Running A Query 2 Time's Before It Get's Results

Sep 28, 2005

Good morning,

I am having some kind of problem. A query in Acces that is used to find results in the DB is asking 2 time's te input.

And there is no way that the input boxes is asking to do this twice..

here is the Query,


SELECT tblHotlines.Hotlinenummer, tblHotlines.Vestigingsnummer, tblDealers.Postcode, tblHotlines.Datum_hotline, tblBestellingen.Chassisnummer, tblBestellingen.Onderdeelnummer, tblBestellingen.[Uitleverings datum], tblBestellingen.[Vervangende auto ingezet?]
FROM (tblHotlines LEFT JOIN tblBestellingen ON tblHotlines.Hotlinenummer = tblBestellingen.Hotlinenummer) LEFT JOIN tblDealers ON tblHotlines.Vestigingsnummer = tblDealers.Vestigingsnummer
WHERE (((tblHotlines.Vestigingsnummer) Like [Geef het vestigingsnummer op] & "*") AND ((tblDealers.Postcode) Like [geef evt een gedeelte van de postcode:] & "*") AND ((tblHotlines.Datum_hotline) Like [Geef de datum op:] & "*") AND ((tblBestellingen.Chassisnummer) Like [Geef het chassisnr op:] & "*") AND ((tblBestellingen.Onderdeelnummer) Like [geef evt het onderdeelnr op] & "*"));

Qhat could be the problem that Access is running a Query twice before getting results

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved