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 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 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 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

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?