Search results

I have on a couple of occasions written a report, and changed the name of the source query at a later date (either by choice or by an error). Is there a way to update the source of a report without having to re-write the whole report? Also would work for a duplicate report that pulls from a...

I have a query that gives me a listing of the count of times an equipment has failed. It is sorted from greates to least by failures. Is there a way for a report to only show me the top 10 in this list, and disregard the remaining 60 or so? Thanks

I got it - I had to remove the Format command and just use the text box properties to set the format. Thanks for your help

I have a text box in a form with the following control source: =Format([Rotating Equipment Count]*[Enter # of Months in Period]/([Unit Count]*12),"0.0000") The "Enter # of Months in Period" should be a user prompt, and used to work. Now it does not prompt, and the result in the box is #Name...

I attempted to build a very large report, that gave me an error of: "The sum of the top margin, the bottom margin, the height of the page header, and the height of the page footer is greater than the length of the page you are printing on." Even after changing to 11x17 paper, I still get the...

I wrote this report using the report wizard. If the code is incorrect, where could I find it to tweak on it? Thanks

Haven't found it in there. Still having the same problem even after re-writing the report.

oops -- continuing; the error is: compile error in query expression '(Year(StartDate)*12+Month(StartDate-1)/1. That is all I can read - there may be more. If I group the report on Each Value of StartDate, it will run. Any Ideas on what has happened P.S. I have even re-run the Report...

I have a report based on a query that sorted the results by month. Then, I don't know what changed or if anything changed, but when I attempt to run the report I get this error: Compile error in query:

Is there a way in Access 97 to asign a macro to a hot key? I am trying to use a ctrl-r or something similar to goto a cover form called cover from anywhere in the database. Is this possible? Thanks

I have a report which will list the number of times equipment has failed in a plant, and with much help from this board, it will now display in order from greatest to least number of repairs. Next step I would like to do - is there a way to chart only the top 10 or 15 pieces of equipment?

Is there a way to select a different report form based on a field in a query? I would like to show one report if the equipment type is compressor, and a different report if the equipment type is pump. Just wondering, Thanks

I am working on a report that lists all of the specifics for some equipment in a plant based on a query. I would like to show a different sketch of each group of equipment on the report. Is there a way to make only the sketch I want visible based on which group the equipment belongs to that is...

I didn't understand your answer. I am trying to count the number of times some equipment has been worked on, and then output the report sorted in descending order of occurences. The count can be on any of the fields in the query or report, it is just a count of "hits". All of the fields are...

I am working on a report that groups data by a particular field. Then I count how many entries for each field. Is there a way to sort the report before it is displayed by descending order of the count of entries? Thanks

This posts a response of #Error in my report. Any other suggestions?

I have a question about counting records in a report. I have a report based on a query called "REMBTF". The field I want to count is "ID" and I only want to count the ID if it = "RW". Can someone please help me with the syntax of this issue?