Recent content by brxmas

Doug, There is no subform, I'm adding records to the form itself. Private Sub Command44_Click() On Error GoTo Err_Command44_Click Dim intnewrec As Integer stDocName = "frmrentals" DoCmd.GoToRecord , , acNewRec Exit_Command44_Click: Exit Sub Err_Command44_Click: MsgBox...

I'm trying to add a new record in my form using a 'Command Buttom'. Below is my code. Private Sub Command11_Click() On Error GoTo Err_Command11_Click Dim intnewrec As Integer stDocName = "frmrentals" DoCmd.GoToRecord , , acNewRec Exit_Command11_Click: Exit Sub...

Nevermind, I can create a formula and group it by it.

SQL 2000 Crystal XI I have a group on a report {class_group_desc} I need to have a DISTINCTCOUNT for each {ad_num} Formula {@emp}: distinctcount({@dist})-1 Formula {@dist} If {mc_period_dates.period_year} IN [2006] AND {mc_period_dates.period} = 5 AND...

SQL Server 2000 Crystal 9.0 I'm having problems getting the following fields to link into my Crystal report: @year, @period, @start_period_CY, @end_sun_CY, @start_period_LY, @end_sun_LY Below is my Stored Procedure CREATE PROCEDURE [bc].[Test_Fri] @year int = NULL OUTPUT, @period tinyint...

select insertion_date = Convert(VarChar(10), mc_ad_insertion.insertion_date, 101) From mc_ad_insertion Where insertion_date >= '03/24/2006'

ODBC 2000 Crystal XI My Stored Procedure is below. I would like to do a ROLLUP on each prod_code. Which is best ROLLUP or COMPUTE SUM to use for quick processing time. I've never used either. I would appreciate anyones help. Thanks in advance. ( @year int , @start_date_CY varchar(10) ...

Denis, I tried both your 'Where' statements and I still get obj_codes 19,29 and 900 and prod_codes 'ELDY' mc_ad_cost_view.obj_code IN (select obj_code from mc_ad_cost_view where obj_code NOT IN ('19','29','900')) and mc_ad_insertion.prod_code IN (SELECT prod_code FROM mc_ad_insertion WHERE...

Hope this gives you a little more insight. For example I do not want to see any records that have an obj_code of 19, 29, 900 and prod_codes of ELDY, INEM. There should only be data for obj_codes 100, 200, 300 and prod_codes of MBDY, MBEX, MBLE. The example below shows what data is coming in...

Need help with using NOT IN in a Stored Procedure. I've tried various ways, but data still is incorrect. Maybe someone can tell me what I'm doing wrong. Thanks in advance for your help. SELECT ad_num = mc_ad_detail.ad_num , source = mc_acct_master_view.source , adv_type =...

That's for everyone's input. I have the query down to 5 min and 12 seconds.....Thanks again.

I really appreciate everyones help in resolving why it's taking forever to run this query via 'Stored Procedure'. What do I need to change to increase the speed? Thanks.

Here's the exec plan. Thanks in advance. StmtText DECLARE @year int, @start_date_CY smalldatetime, @end_date_CY smalldatetime, @start_date_LY smalldatetime, @end_date_LY smalldatetime --SET @start_date_CY = '11/28/2005' SET @year =...

I looked at the 'Execution Plan' and there are table scans. What can I do to improve the process? Thanks in advance for your expertise. Below are the Statistics. Application Profile Statistics Timer resolution (milliseconds) 0 0 Number of INSERT, UPDATE, DELETE statements 0 0 Rows...

The db has 53,742 records. And, it took 12 minutes to process. Thanks.