Search results for query: *

Want to thank everyone for their help. I have located the problem and fix it, and the formula works perfectly. Turns out that the person who set up the fields us LINE and LINE NO. My relationship was from LINE NO to LINE NO...seemed logical to me! .... oh no, he wanted me to use LINE but...

Hey Lbass, The ship date isn't always blank. In fact it was a recent addition set up as an Access front end and Oracle table. This means that the new table has much less data in it, than the oracle tables. There are 6 tables, using left outer joins which worked fine with the requirements of...

Hi lbass, This is my record selection formula. I need to pull the report based on the "wanted delivery date", then show when it shipped, then calc to show that it was On Time, Late, or did not ship. This is in another field on the report. {CUSTOMER_ORDER_LINE\.WANTED_DELIVERY_DATE}>= {?Select...

Good Morning all, We use Crystal 8.0 - Oracle. Basically we're trying to have the report use the "ship date", unless it's blank. In that case, use the "Real ship date", otherwise use the "ship date". Here is my formula: if isnull ({CNX_DAILY_SHIPMENT\.SHIP_DATE}) then...

Hello All, We are using CR8.5 and I am trying to eliminate records if the string DATA is part of the part number field, AND the unit price is 00.00. This is what I have so far, but it won't work. IIf ({CNX_DELIVERY_PERFORMANCE\.SALE_UNIT_PRICE}="000")and...

Good Morning All, I have a questions that I'm not sure how to ask, but will try anyway. We are using V8.5. This report includes all part numbers except in the following instance: When a part number contains the string DATA AND the unit price has dollars, then include on the report. We have...

Hello All! I'm in the process of converting to Access 2003. I have converted the front end to this, but am still linked to the Access 97 backend. This is a very active database and can not be shut down for any lenght of time. My problem is that while I am updating the forms, reports etc in the...

Good Morning, We are use CR 8.5 and have a date field which is stored as date/time. We'd like to highlight in red, any date which is prior to a specific date, 1/1/2000 for example. The Highlight Export works for currency and numbers, but doesn't appear as an option on date/time fields but not...

Good Morning, I have very sensitive data on my computer. I shut it off every evening before I go home and there are times that it is on when I get back in. This has happend very frequently in the last month. Is there a way of finding out who was on my computer? I have Windows 2000...

Thank you so much! I works very well.

Hi, I need to calculate the difference between a Delivery Date and an Actual Ship date. The results needs to be an X if the Actual Ship date is "earlier" than the Delivery Date. In another column, I need to show an X if the Actual Ship date is "later" than the Delivery Date. I need a...

mbarron Thank you so much. I've been away from this for a little while and had forgotten. It works great now! Jellybead

I have a list of names that need to be changed to their full names. The database hold it by first inital, last name. The formula I have right now is: IF {PROJECT.MANAGER} = "DLEE" THEN "DIXIE LEE"; IF {PROJECT.MANAGER} = "EROTHE" THEN "EMMETT ROTHE"; IF {PROJECT.MANAGER} = "SPERRY" THEN "STEVE...