Recent content by jmh944911

Good idea. I do not get the same problem in the new wizard/manual modified report. The actual report is very complex so this proves that somewhere in my complexity is the issue. You know... I used to have a philosophy that all the work should be done in the tables. Then I converted to a report...

You should identify if your issue is with the data in the table or the query getting the data for you. I imagine that you have some data that is not anticipated in one or more of the columns.(zeros or nulls) as such your query sort flattens that data. say your table is this a 0 z 1 _ 0 z 1 b 0...

Good thinking but I looked there already. The comma is my thousands seperator and the period is my decimal indicator. I appreciate the assistance.

I have a very interesting thing going on in one of my reports. I have the same number format defined for detail and summary records in a report(standard with 0 decimal places). The formats display differently in the detail section the thousands seperator is a period in the summary it is as...

I thought I knew how to do this but I guess not. I have a form with 3 sub forms. Each of these subforms has a grandtotal that I want to move to the mainform. Form is like this: Formheader detail subform1 subform2 subform3 (sf1grandtotal + sf2grandtotal)/sf3grandtotal = displayvalue...

sorted it out The running total value can be used to solve this problem. One keeps a local total and a running total of each group by turning off the the property for one textbox and on for another. With these two values one can keep track of each group subtotal. Here is a small example...

Design suggestion for item 2 There needs to be some way of connecting the expense records to the order. If you have an established internal identifier then use that to join the records from expenes and orders (assumption that they are in different tables). If there is no unique ID then you...

suggested design changes for item 1 You can accomplish what you want. :D I suggest that some small design changes will make the whole thing simpler. 1) create a query for your source table. Use the inputs from the form in the query something like this : Between [Forms]![frmReport Menu with...

Greetings to all, Sample for discussion - Final *look* of report: PageHeader Section1 S1 subtotal Section2 S2 subtotal TotalMass = S1sub+S2sub Section3 Section4 Section1 and Section2 have subtotals values for a weight value. I want to retain these values so that I can add them...