Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. stuckDuck

    Filter Details to Diplay 1st and 5th record

    Thank You for the promt reply. I have tested both forumlas and they suppress all the records including the first and fifth. I was thinking of getting the sum of the record count. If the sum is less than 10 then suppress all the records in the detail section, however I cannot sum the count...
  2. stuckDuck

    Filter Details to Diplay 1st and 5th record

    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...
  3. stuckDuck

    Average Formula Help.

    Try using the Running Totals and Use the Average feature. Then place it in the group footer.
  4. stuckDuck

    Shorten String

    yeah thank You!
  5. stuckDuck

    Shorten String

    DATE1 = totext(datetime({Anaheim_Import_Data.Incident_Date}),"MM-dd") DATE2 = totext(datetime({Anaheim_Import_Data.Total_Date}),"MM-dd") I cannot do the math of: if not(isnull(DATE2)) then DATE1 - DATE2 I tried tonumber(totext(datetime({Anaheim_Import_Data.Total_Date}),"MM-dd") and several...
  6. stuckDuck

    Shorten String

    This worked perfectly to display the data. totext(datetime({Anaheim_Import_Data.Incident_Date}),"MM-dd") It does not let me perform simple addition or subtration.
  7. stuckDuck

    Shorten String

    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"?
  8. stuckDuck

    How to insert an image in a report

    From the Menu Bar: Insert --> Picture --> Browse for photo
  9. stuckDuck

    Cross Tab - Print Time Formula Not Working

    thankyou, i will try your suggestion. The running total was used to get the integer sum. I guess the cross tab summary field handles that.
  10. stuckDuck

    Cross Tab - Print Time Formula Not Working

    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...
  11. stuckDuck

    handling disagreement with senior team member

    Thank You all for the replies. That was great perspective. I stated my reasons why I think its appropriate to update the user id and sent it in written form to my senior team member. If there is still disagreement then I will ask the senior member to inform the user.
  12. stuckDuck

    handling disagreement with senior team member

    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...
  13. stuckDuck

    Trigger to subtract values from different tables

    thank you thats exactly the error message i received. I will try this suggestion.
  14. stuckDuck

    Trigger to subtract values from different tables

    I forgot the subtraction part.. select pay_amount - balance into :new.balance from payment;
  15. stuckDuck

    Trigger to subtract values from different tables

    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; /
  16. stuckDuck

    Not Able to Drag Database View into Web Page

    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.
  17. stuckDuck

    Print Subreport Date Paramenter on Main Report

    in a section below the one containing your subreport. Is there a workaround for this? My subreport is in the group footer but I need the date in the page header.
  18. stuckDuck

    Print Subreport Date Paramenter on Main Report

    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...
  19. stuckDuck

    Trying to write exception into trigger

    I fixed it!!!!!! Thanks abunch. this is now closed. I'll edit w/ solution for reference later.
  20. stuckDuck

    Trying to write exception into trigger

    Thankyou for your help. There are some changes and now the code should assign XX to BLD (i,J) if the B021 is present. I added a while loop, but not able to test it yet. SELECT COUNT(*) INTO V_PV_COUNT FROM C_ACTION WHERE C_CNO = :NEW.CSM_CNO AND C_TYPE =...

Part and Inventory Search

Back
Top