Recent content by Gavroche00

Duane, When I try to copy the calculated field to the main report, I get Access asking me to define my fields. How do I copy the cell to the main report? For example, in my sub report I have txtTotal which is [gradea]+[gradeb] When I insert an unboud text box in the main report header and...

Duane, Can you clarifiy your posting. I am trying to get a calculated text box total from one sub report to the main report and it doesn't work. So let me first ask, can it be done? If so, I use a IIF function in the main report, is that correct? Thank you David

Hi all, I am getting more and more confused and I thought I knew Access :) I have a master list of all student ID's which is the primary key from that table. I have left joined that table to the grade table (which has student ID's, grade and date). I want all the students to return a grade for...

Henry, Sorry for not being clear enough. I have a student table, and I have a grade table. The grade table has 3 fields: studentID, WeekNo, and Grade. What I would like is simple but I don't know how to start it. I wish for every student to have a grade. The ones that never turned in a grade...

Hi all, I have 100+ students that can come at any time during the week and turn in a report. I then enter their mark in my Access DB. However, some of the students don't show at all. I can find out who they are by querying from a master list with 'null' in the report field, but I would like...

Sorry Guys, I found it: Ccur(Clng([txtbox]*100))/100 Thanks for the help David

Dear Crowley, Yes I did already. There is a limit of 2 dec. in each field. Dear Duane, Yes I did. So it does display with two digits past the decimal. However, take this example. $23.08*$4.33 = $99.936. Even though it will display as $99.94, if I use the text box for another calc, I will...

I am drawing a blank. I have a calculated field in a report giving a currency readout (2 decimals). However, there are more then two decimals when it calculates it. I forgot where to go in the table or the query to require that the raw data is also two digits only. I.E. I have the amount $23.15...

Bob, If I save two queries depending on the criteria in the calculated field, I just need to call it then? Me.recordsource = "qry_greaterthenzero" for example? Thank you David

Absolutely, that would be a great idea. David

Bob, My calculated field is of the sort total:([a]+[b]+[c]). I understand a criteria such as total>0 but how do I enter a criteria with both options? I need two printouts, one for positive and one for negative values. If I write total >0 on the first line and total<0 on the second, I believe...

Thank you very much. Of course, once someone tells you, it is so obvious...Duhh. David

I have a report that goes on a pre printed sheet where several boxes need to be marked. Unfortunately, the option group is not good because I need specifically 'X' in the box instead of the check. Does anyone know of a substitute method to use? Thank you David

Bob, The calculations are done in the report itself and not in the query. Are you saying to add a field in the query that calculates a total and then create an option depending if the result of that box is >0? Thank you David

Thank you all very much, it worked both ways. David