Recent content by Wayne79

right clicking and choosing open results in the the query being run twice on the server. Same as double clicking.

I've run across an interesting bug in Access and/or SQL Server. My set up: Access 2007 SQL Server 2008 Here is a way to see what I'm talking about. In Access create a pass through query. Use any legit DSN. For the source use Select 1 don't save yet though. open profiler and set it to look at...

I'm looking for a way to easily tell yesterdays date in a business week. I can get Tue through Friday easily enough but I can seem to get Mondays yesterday (Friday). Thanks in advance for any assistance.

That worked. Thanks for the assistance.

CR thinks the fields are strings. I do not get a tab to format it like I do with numbers.

used both CDate({RPT_CBC_BILLING.PICKUP_BY}) and Cdate(Left({RPT_CBC_BILLING.PICKUP_BY}, 10)). Neither worked. Still the sum could not be created error.

Using CR8.5, DB2 v7 I am writing reports against a series of table where the dates are defined as DateTime. Here is a sample of the fields data: 2004-11-07-21.00.01.000000 I create a parameter and set it's data type to be date, range values. In the report record selection criteria I enter...

Reason is report, with details hidden, looks like this: Page Header - Field1 Field2 Field3 GF#2 Summary- Field1 Field2 Field3 GF#2 Summary- Field1 Field2 Field3 GF#1 Summary- Field1 Field2 Field3 Report Footer-Field1 Field2 Field3 Page Footer Gaps...

Unsuppressed GH#1. Clicked underlay for GH#2 and GH#3A No effect. Added GH#1 No effect.

Group headers 1, 2, 3A are all suppressed. Clicked the underlay check box for GH#2 and GH#3A - no effect. Clicked for GH#1, GH#2 and GH#3A - still no effect.

Tried checking the Underlay Following Section checkbox on the Report Header Page Header GH#1 GH#2 GH#3 A GH#3 B individually and all together. Still not working, or else not working as I'd like. Is there any way I can tell if it is working? What I'd like to happen is the GH#3 B space be...

I moved the subreport to the GH#3. after creating a A and B sections. A is suppressed and B is not but it needs to be. Same problem as before. Compressed the subreports as small as possible but unable to hide completely. Did the Underlay thing and it didn't work either.

In the section expert I clicked the Details B section and then clicked the Underlay Following Sections checkbox. I did not add any code. Is this correct? if so it appeared to have no effect. Working on the other changes recommended.

Underlay Following Sections didn't work.

Using your idea in the sub reports worked like a charm. All sections suppressed, formula in the report header. The formula could probably go anywhere though I'd imagine. On the main form I left the sub report in the detail B line but moved all the fields to the C line. Unsuppressed the C line...