Search results

Well, that's what I figured. Nothing's ever simple :rolleyes: Okay then. If you can post a simplified version of the db I can probably get you a report pretty close to what you want. Basically, I'd need a copy of each table with some dummy data in each so I can get a feel of it and see what...

In the Detail_Format code section of the rpt enter something like this. The jan, feb, etc should match up to your field's correct names. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim sglActual As Single sglActual = 0 If jan <> 0 Then sglActual = sglActual + jan If...

Hey Bob! Do you have a lot of customers and a lot of glcodes? The thing is, the complexity of the report will really be affected by the number of variables involved. Also, where is the data coming from? Is this going to be loaded by hand in tables or imported from somewhere else?

If you used the chart wizard the SumOf prefix showed up on the 3rd page of the wizard, the one that says Preview Chart. At the top left there's a box that says "SumOf" & whatever your field is. If you double click the box a new window opens that gives you the Summarize options. Choose "None"...

In page setup for the report, go to the columns tab. From there you can set up the number of columns, width, direction, etc. The attached db has an example report. Hope this helps!

Hi jennypretty! I'm a little confused about what you have here. Where are the values you want to print coming from? Are they in a table or on a form or ? If they're in a table you should be able to query them and make a report from the query but I don't know if that's what you have. Can you...

I don't think I got your table setup the same in this example but it should be close enough. What you can do is add some vb code to the report detail and page footer sections. The attached db has a sample table and report. If you view the code in the report you'll see how it works. It's fairly...