Recent content by Tawcan

Hmmmm ok...I think I know what you're thinking... Right now the database works in such when you click a button called "VIEW GRADE REPORT" on a form it opens up the report. The report contains bunch information, as well as the session average report (used sub form/report). So basically what I'm...

Here's a sample table I'm trying to work with. http://www3.telus.net/tawcan/data.xls I'm trying to calculate session averages Formula: Sum(GRADES * ACT CREDITS / ACT CREDITS) And then display these session averages on a report.

Well I have 3 days to figure out this. :o Could you tell me how I could do this dynamically then? Like do calculations directly and stick the results onto my report?

I know it's against normalization rule... but considering that the database isn't normalized at all I don't think I need to worry about that. (Normalization will happen later on, but want to finish this first). Is there a way to do this in real time then? :confused:

I've been working on this particular sub for a while now. Basically the sub reads a table, pulls data out of this table, does calculation, then inserts results into a new table. The table that gets read has bunch fields, but I'm interested in the GRADES and SESSIONS. Due to some administration...

Just came up to my mind.... the values in GRADES are all string... though they might be 90, or F. Thinking & searching....:p

Using Office XP, so Access 2002. IsNumber couldn't be found on the help. :(

I'm using ADO to create a recordset which orders the existing table by session. The problem I ran into before was when I tried to do calculation, sometimes I get a NULL error due to the fact some cells are missing values. Would this work? Dim num as Integer num= num + CInt(Nz(res("GRADES"))) *...

Ahhh sorry. So I can use IsNull("GRADES")= FALSE to exclude the cells that don't have a value. But what about cells that contain either "F" or "P" ? Do I just do something like tb("GRADES") <> "P" AND tb("GRADES")<> "F" Or is there a function that will do that? Like searching for numerical...

Hi, Right now I'm trying to pull values out of an existing table then do some calculations. The thing is, not every cell in this particular column has a value, furthermore, I only want numerical values. Before I had this kind of if statement but I don't think it works If tb("GRADES") <> "...

???? That was a copy and paste from earlier before you told me about that.... I've changed it on the current database.... :)

Basically I want to create a new table called SESSION AVERAGE. Then do some calculation, and stick the session year into SESSION, and session average into SESSION AVERAGE. Then use this table for SESSION AVERAGE REPORT. (Yes I know, if I normalized the table I could do it easily.... :p) I tried...

Sorry, don't really know how to use SQL though I know it's super simple... :o :o :o Now I can create table successfully using: Dim dbs As Database Dim tbs As TableDef Dim fld1 As Field Dim fld2 As Field 'Checking if table exists, if yes delete table If ObjectExists(acTable, "SESSION...

I know, but that means reconstructing the whole database and I don't have a lot of time. I'll write a recommendation for the next person that works on the database. Thinking creating only 1 SESSION_AVERAGE that gets updated each time... Back to the topic... now I have created a new...

I think so too. :D I'll give it a try on Monday at work. :)