Search results for query: *

Try a series of selective queries, changing your "WHERE" clause. You may find you can get some or most of your data. Maybe even figure out the bad record and use a query to delete it. This may take some time; treat it like a binary search and keep changing your target.

In Access2000 (and later, I guess), you can use built-in functions as default values, including "IIF" and "Date()". It doesn't seem to be well-documented, but go to the "Default Value" property of a field and get the dropdown to see most of what's allowable...

FOUND IT! Turned off the "Keep Together" flag for the detail section. WHEW!

Ken Yes, I compacted and repaired; made no difference. Based on your comment, I decided to make the simplest version of the report and data that would cause the problem. I eliminated code, records, report sections. AND I FOUND THE PROBLEM (not the solution, yet). If the subreport contains more...

This can happen if you change printers. You didn't describe your environment, but if you change default printer (for example), pages can reformat.

I added a supreport to a working report, with master/child fields linked properly. Report runs for 30 or so pages then starts producing the same header with no detail for what looks like infinite pages. Deleting some subreport data moves the problem to a different page. Tried the same software...

Try two Left Joins: SELECT whatever FROM (PartTran LEFT JOIN ShipDtl ON PartTran.field1 = ShipDtl.field1) LEFT JOIN ShipHead ON ShipDtl.field2 = ShipHead.field2 This works in Access. Gets all PartTran records whatever fields are selected.

Using .net (VB). The rulers for a report changed from inches to metric. In one project I now have one report with a ruler in inches and one in centimeters. The only help I can find says check the Windows settings. I did; they're still U.S. Has anyone run across this?