Replies

Thank you John. I had used this approach without success. It worked with the queries, but didn’t work on the report. Go figure why the numbers would change layout from what the query reported to the report. Finally used the suggestion from Staphane and got the report to work correctly. Fay

Try setting the Format property of the controls on the report to Fixed, then specifying the desired number of decimal places.

Thank you Stephane the int worked. I appreciate your help. Fay

It seems that you are changing the display of the numbers, not their values. Use functions like Round() or Int() — Int(MyNumber*10+0.5)/10 rounds a number to its first decimal for example. Depending on your database engine, the names of the functions may be different.

Thank you that did the job. Fay

Try:
=iif([classifications]=0,0,[clients]/[classifications])

edited to add closing parenthesis

Boy was that dumb. I thank you. I was over thinking the process. Your suggestion was right on. Fay

Thanks Hans. It didn’t work the initially. I closed and walked away to come back and it worked. Magic! Fay

Here it is. I fiddled with it more this am. The only thing achieved is one less tree and one more headache. Everything prints as it should until you go to section three or the Introduction. (I.E. page i on right and page 68 on left on flip side page ii and 67 are together. Once it gets to the Introduction or page 1 instead of it print on the right side of the page I get a forced Windows blank page and page one is on the flip side paired with page 2 etc. As you can see by the title of the file my patience is shot and definitely my problem solving ability is shot. Thanks for any feedback. Fay

I just checked the document. There are only page or continuous section breaks inserted. Good thought, but… Any other ideas? Thanks for this one. Fay

To close to it. Didn’t think I could use an expression in the Field Value is area. Stupid of me. Thanks I got it working. Fay

Thanks Hans. I will get to work. Thanks for the help. Fay

Oops. Didn’t catch that. That did the trick. Thank you very much! Fay

Thanks for your response. That didn’t do the trick.

Fixed it.

Thanks John haven’t tried your method yet. Hans’ method looked quicker. I think I did as instructed but got a Enter Parameter Value dialog box. If I click okay get runtime 3464 error message “Data type mismatch in criteria expression. If click cancel get the cancelled message.

strSQL = “INSERT INTO tblCombRequiredCerts ( Renewed, Due, LearnerID, ClassName, DateOfClassStart )” & _
“SELECT tblCertificationTypes.Renewed, ” & _
“DateSerial(Year([tblCertificationDates.Date])+([Renewed]),Month([tblCertificationDates.Date]),Day([tblCertificationDates.Date])) ” & _
“AS Due, tblCertificationDates.LearnerID, tblCertificationDates.Type, tblCertificationDates.Date ” & _
“FROM tblCertificationTypes INNER JOIN tblCertificationDates ON tblCertificationTypes.Certifications = tblCertificationDates.Type ” & _
“WHERE ((([tblSession].[DateOfClassStart])=Now()))”

Boy that was stupid. Didn’t even think of that. That fixed it. The only question I have is this. Why when you tabbed through the LearnerID box would the number appear even though it had the wrong name?
Agency and staff are given a number by payroll.
Thank you.

Fay

Sorry. Here is the database. Thank you. Fay