Search results

Hi again folks .... I spent most of the day today manually aligning (adjusting/moving fields, preview report, adjusting, previewing etc etc) page headers and detail records for a financial forecast report with monthly revenues in the 8 figure range, e.g., $33,000,000, and ranging down to zero$...

Even though I was able to figure out a work-around solution to the above mentioned problem (by using individual option boxes vs. am option group, each of which calls a macro on click to run the requested report), I'd still be interested in hearing if someone knows how to accomplish what I...

Its probably a lousy subject title for my problem but the overview is this: The objective is to let field sales reps run a basic access applicaton (only a switchboard and report request option/form and of course an exit Access button) so they can take the report to a specific dealer, showing...

Thanks for the idea, Gino, and I will double check the formula, Pat. Actually an Access Guru from another dept. setup the initial function calc. and now that I think about it he had to use the tablename as well as the field in something like.. NZ([tablename]![fieldname],0] Not sure why he...

I have tried to use the NZ funtion to clear up the null problem in query totals for reports (it works fine for the first field defined then doesn't work for the other fields). Have also tried basing the NZ function on the direct-table querie and another on which the report is based on an...