Search results for query: *

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

Sorry if this is the wrong forum, but I need to break down an amount in a report I am writing. Let say the amount is $1,045.34. I want it to read only the 1045 and then the 34. What is the format command for that please. My Textbox will look like 'The amount of '&[whole]&'dollars and...

I have a report where if the value of salary is >0, I want it printed on check paper, and if value = 0 I want it printed on regular paper. I have 70 records in the report, with one page per record. Where do I specify the batch request and can I request both at once? Thank you

Thank you very much Duane. That was what I was missing. Now I get it. David

Duane, Thank you for the message. All I am trying to do is is sum a list of expenses that are record specific. However, if I create the sum in the detail section, I get the sum of all the records. Rent: 30 Fuel: 40 Taxes: 10 Total should be 80 but it is instead the sum of all 3 fields (rent...

Duane, When you write 'section', you mean from detail to footer for example? David