Search results for query: *

I want to create my own "greenbar" printouts. That is, I want to shade every 5th row of my printout. I'd prefer doing it without using vba... possibly using the conditional formatting feature of my A2000. I was thinking of doing a record number divided by 5 and shading every row that...

Why not create each unique report that is needed. Then chain them together in a macro that has several steps. Apply the KISS principle here. Create two or three simple reports. Set your reports to PRINT not PReview. Then experiment with chaining them together in a macro. Further Questions...

Check your Access helps for "Keep Together Reports" JC Johnstown, OH

I'm not much for basic programming so what I once did was create TWO Fields on the report RIGHT ON TOP OF EACH OTHER!! One field uses an IFF statement condition that will show if the with the shaded background. The IFF statement condition will show the data in an unshaded background if it's...

Make a copy for security of JUST THE QUERY. Then start deleting one QBE field at a time, till the thing quits hanging up. JC Johnstown, OH

You do things backwards from me. I like to create a query and get it working to grab the records I want, then create a form or a report to show the results. Don't try to solve the whole thing all at once. I say again, get the query working then base the form or report on the query. I get the...

I'm not sure, but maybe you'll need to create a second query that calls the first query. Johnstown, OH

I hope you get better response than I have. I've had this same problem posted on the reports forum for a long while and no answers. I feel like quitting answers other people's questions. Johnstown, OH

Reports have filter properties that you can play with. I'm chicken though. I like to always create a QUERY first, to get me the DATA I want. Then I create a report based on that query to give me the LOOK I want. More flexibility, less brains... that's me.

I don't think this is a toughie. I create most of my reports by building a query first and then generate the report from that query. This way gives me much more control over my report. I'd just create two different queries based on the different users menu choices available. Then I'd generate...

one thing I forgot. You may have to extend the field size down just a bit, and pull the lower border up so that your colored field is continuous and not have little white gaps between colored blocks. Johnstown, OH

in the design view of the report, highlight the DETAIL segment and click on one of the fields. In the properties box of that field change BACKGROUND COLOR to anything you want, even color. I would not get to spastic on this, though. If the report needs to be xeroxed, it could get ugly. Maybe...

can you use the report wizard and group by question and within that group by employee? When you get the group hiaracy like you want, just tell the wizard you want avgs, sums, and all that stuff. I have found the wizard is really powerful, but you have to keep your eye on the ball. Johnstown, OH...

I don't think the previous "helpers" for Gordon understand his question. Gordon is like me and many others. When the File explorer was revised for ME they changed some stuff having to do with the "my documents" and other stuff. If you right click on start or go to...

I cannot get an access 2000 application I've created to save the report in landscape with or without additional changes to the margins. I can as long as I stay in the application it stays landscape. Even if I use the report wizard it still goes back to portrait.