Recent content by stuckDuck

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

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

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

yeah thank You!

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

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.

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"?

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

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.

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

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.

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

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

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

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; /