Search results for query: *

Excellent discussion - thanks.

Thanks again - but unfortunately the label gives me the same generic proporties as the textbox

Yes that's the problem I'm in Access 2000 and although I get the intellisense for txtUnsatisfactory, the properties available are not normal text box properties. There is no text or value property. thanks

Yes, well I know VB ok, and I know how to get to the code in a report, but the Access specific stuff I don't know. I have a textbox on the report, as a simple string variable in the code. thanks

I need to pass a value from the open event in a Access report and display it on the actual report. This has got to be easy, but I don't know much about Access!' thanks

Thanks - but all that happens is that I get prompted for values when the report is run. Here are my field names and formula as it appears in the textbox =Sum(Abs(Students.ADeconOverall ="Excellent" OR Students.BDeconOverall="Excellent"))/Count(*)

I am not familiar with SQL in Access but I need to do the following: Given a simple select statement, I need to determine the percentage of those records that have the value "Excellent" in one of two possible fields. I do not care if it is done in the report or in the query itself. How do I...