Search results for query: *

I need to supress all the records in the detail section of a report if the record count is less than 5. If the record count is greater than 5 then display only the 1st and 5th record. I have a running total formula that performs the count however it is not suppressing the 1st record if the...

In an access database the field "date1" is a text datatype that is formatted as "yyyy-mm-dd hh:mm:ss" How do i shorten this to display only "mm-dd"? I'm getting the left side but i need it to cut off. LEFT({Anaheim_Import_Data.Incident_Date},6) How do I convert this to "mm-dd-yyyy"?

I need a cross tab that sumarized the time for each department. The time on the database is in integers. I need this formula to format the time in a useful manner. I receive an error " A print time formula that modifies variables is used in a chart or map" Help Appreciated! NumberVar...

I'm the junior member of a application support team. A user requested to have their user id updated due to a name change. The windows team has already updated the users id and email. However for this specific application we cannot update the existing id. We will need to create a new one and...

i want to automate the subtraction of the pay_amount from the balance. The columns are on different tables? create or replace trigger test1 after insert or update or delete of pay_amount on payment for each row BEGIN select pay_amount into :new.balance from payment; END; /

When I need to view sqlserver data I can drag a database table directly onto the webpage. I am unable to drag a database view. I am trying to display query results and I saved that query as a view. Help appreicated.

Help Appreciated! My subreport has date parameters in the page header. I would like to print that date parameter in the page header of the main report. I tried a shared variable to no avail Sub: whileprintingrecords; shared datevar x:={?end_date}; Main: whileprintingrecords; share datevar x...

Im updating a trigger. I am trying to create an exception such that if v_pv_count > 0 then do not go into the loop. It is not working. Help appreciated. SELECT COUNT(*) INTO V_PV_COUNT FROM C_ACTION WHERE C_CNO = :NEW.CSM_CNO AND C_TYPE = 'BLD'...

My trigger compliles but is invalid. Help appreciated. For each user_id I want to generate a random pasword. dbms_random.value is a system package that generates random characters. ************** create or replace trigger trigger_password_generate after insert or update of "USER_ID" on...

I am trying to join two tables that have a 1 to many relationship. Is this an outer join? I am getting duplicate records. ie where a.TableOne = b.TableMany (+)

From a subreport, I want to display the follwing information in this order onto the main report. 1. Named Billing Party, 2. Owner, 3. Tenant I have the record selection expert set as this order but the records do not show up in this order on a consitant basis. The Record Sort Order will not...

I have sequencing data. In the group footer I am trying to sum the amount paid. For some reason I am getting duplicates. It seems to happed ramdomly. I am unable to suppress in the group footer or in the details. 1Group Header: Bank 2Group Header: acctno Details(suppressed): acctno, amountpaid...