Search results for query: *

Do you mean that you have a macro set to run on the event "On Enter" of the subform?

You can make a copy of it and strip out the data in the copied version...add some bogus data maybe

You cna just zip it and send it to me if you want...my public e-mail address is nfusee@aol.com That way I can see what you got going....

Yep..what is the structure of the database?

I like the Crosstab query Idea too.....it really depends on how you have your database setup, though...

So, along the same theme...just take the labels off the text box fields....make one report, then copy that one and change the Control Source to the table or query for the next hospital, ect... Then on the main report, you just have the Category and ROw labels and the 6-9 subreports...

Can't you just use Conditional Formatting? From the toolbar: Format - Conditional Formatting

Post one of your formulas...if you just choose "Percent" with the FORMAT property (just under Control Source property)you should not have any problems... Control Source: =[Field1]/[Field2] Format: Percent

Assuming your problem is getting all 6-9 hospitals to show on one report.... You can simply create a separate report for each hospital with all 13 categories, then in another report put all 6-9 reports in it, as subreports.....

Anyone figure this out..I have the same thing...had the red one and redid the scope, now I have the blue one

1. On the properties of the form - change Record Selectors to be "No" 2. Many different ways, but the easiest for a beginner is to create a macro. New-Macro GO To Record - New Have that macro run on Open property of the form..

Yes, take the parameter out of the query. Then, under the criteria of the field you want to use put this: [forms]![your form name]![combobox name] Create a popup form and add one unbound combo box on it. The underlying data of the combo box is of course the field you want to have input...

Excel 2002 does this....

Yes, you can....

How are you linking that date search form to all those subreports?

Just use the command button wizard for the search. Choose Find Record from Record Navigation in the first step of the wizard when you place a command button....

I need to see the report and what you are typing in the control box...make sure you use the ( ) and also try putting an = before the statement...otherwise, like I said I need to see it.... How about e-mailing me a screen shot of the statement...

To add upon the previous help...you may want to nest the IIF statement as well. To use the the example the previous user sent in.... IIf(COUNT[JOBS]= 3, "VERBAL WARNING",IIF(COUNT[JOBS]=6,"SUSPENDED","")) This states that if the count=3 then they get a verbal...

Sorry, but I don't quite understand what you are trying to accomplish, but I may be able to help you if I understood what you are trying to do. I need more information -Nick

1. Create an unbound textbox for each parameter in the header 2. Right click and go to properties of the textbox 3. Set the Control Source property to what you specified in the criteria of the query. Ex. Between [Begin Date] AND [End Date]. Set the control sourceof the first textbox to [Begin...