Search results

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...

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") <> "...

I'm trying to create a table automatically (like when a button is clicked on the form), but am stuck. I'm not 100% sure if I need to use SQL or not to accomplish this. Really new to this stuff so please help me. The follow is the code I have right now. When I tried to run this I get an error...

Having some wierd report display on my report... Basically I have a main report where 6 reports are linked to it by using subreport. On these 6 reports there is an area for displaying annual average (database for school). The calculation code used: =DSum(" [GRADES] * [ACT CREDITS]...

Not sure if this is the place to post this since the question/problem involves filter, query, report, and VB... :o Ok I have a database which contains bunch student records in different years. So a report on student progress can be 1-5 pages long. Before I was trying to manipulate the display...

I posted the following question on Report Forum: Say I have a report that's 10 pages.... is it possible to display only a certain page (ie page 2 only) on the report view? If so how could I do this? Someone said: There is a Pages Collection which has Page as the Object ... and then you can...

Link queries to reports dynamically so different queries will call up depending on the # that's entered? Queries: 12345678 Page 1 12345678 Page 2 23456789 page 1 23456789 page 2 Report 1 -> can be linked to either one depending on the # entered. Report 2 -> same as above. Right now my...

Does anyone know how I could automatically create queries with different criterias when a button on the database (form) is clicked? I think you need to do some VB coding, but I'm clueless.... :o

Right now I want to create a new table on my database. This new table is used for the failed course report. To create this table the database needs to go into each student's record and look for grade that's lower than 50%. I'm not too good with coding, so how would I be able to do that...

Hi, Say I have a report that's 10 pages.... is it possible to display only a certain page (ie page 2 only) on the report view? If so how could I do this? Thanx.

Hi, I'm working on editing an existing database where I need to change the current report layout. Basically, the database contains bunch records of students such as grades, and which courses they took. Right now I'm working on a report called "APR Report." The repot separates the student data...