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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: acr1
  • Order by date
  1. acr1

    Valuation Date Formula using 'Previous'

    Fred I agree that there are multiple deprec recs..and should have been more specific at the start.. I think I will rewrite the query or try SQL..our thread seems to be getting out of hand. Thanks for your input anyway.
  2. acr1

    Valuation Date Formula using 'Previous'

    1. Do you want one line per compkey? - Yes 2. Is there one ASSVALUE line per COMPEQ or multiple. - one ASSVALE 3. It looks lines there is mutiple ASSDEPRE per ASSVALUE. Correct? - Correct Yes ...monthly depreciations.. TIA
  3. acr1

    Valuation Date Formula using 'Previous'

    Fred SQL as follows out of the crystal report.. SELECT COMPEQ."AREA", COMPEQ."COMPKEY", COMPEQ."PURCDATE", COMPEQ."UNITID", ASSVALUE."ACQDATE", ASSVALUE."CAPTLEXP", ASSVALUE."EXPLIFE", ASSVALUE."INITCOST", ASSVALUE."REVALAMT", ASSDEPRE."ACCDEPREC", ASSDEPRE."DEPRECAMT"...
  4. acr1

    Valuation Date Formula using 'Previous'

    Fred CR 8.5, and Oracle 8i db Based on other selection criteria (I dont think we need to go there) but as follows... One @DateNOtEqual {COMPEQ.PURCDATE} <> {ASSVALUE.ACQDATE} Two @DateVariant Abs ({COMPEQ.PURCDATE} - {ASSVALUE.ACQDATE}) Three @datediff {@DateVariant} > 366 //Greater than 1...
  5. acr1

    Valuation Date Formula using 'Previous'

    Hi Fred I inserted the line ASSDEPRE."DEPRECDATE" = '30 JUNE 2003' as an example but it is not in the SQL WHERE statement behind the report..sorry about that. I have tested ASSDEPRE."DEPRECDATE" = '30 JUNE 2003' and I know it works and only brings out 30 june 2003 data.. So I am back to...
  6. acr1

    Valuation Date Formula using 'Previous'

    Hi Fred Is it possible to run what we have communicated.. in SQL .? and changing the 'deprecdate' parameters below.? WHERE COMPEQ."COMPKEY" = ASSVALUE."COMPKEY" AND ASSVALUE."ASSVALKEY" = ASSDEPRE."ASSVALKEY" ANS ASSDEPRE."DEPRECDATE" = '30 JUNE 2003' TIA Angus
  7. acr1

    Valuation Date Formula using 'Previous'

    Hi Fred Me well Wellington NZ and thanks again for your prompt response. It did not like the 'max' as was wanting a field , time, string, booleen, etc.. but when running still brings out the whole db of 4000 plus recs. Scenario 1 is correct. Scenario 2 would be 29/06/2003. I need 30/06/2003...
  8. acr1

    Valuation Date Formula using 'Previous'

    Hi Fred Once again thanks for your prompt reply..where are you geographically.? The Formula is If ({ASSDEPRE.DEPRECDATE}) = Date (2003,06,30) then {ASSDEPRE.DEPRECDATE} Else Previous ({ASSDEPRE.DEPRECDATE}) which is not working properly as it extracts approx 4000 records aand I only want...
  9. acr1

    Valuation Date Formula using 'Previous'

    Hi Fred Thanks for your prompt advice however it does not appear to be displaying previous dates..for records that are one date previous...
  10. acr1

    Valuation Date Formula using 'Previous'

    Hi All I am trying to get the last valuation date using "previous" if the date is not the 30 June 2003.. I wish to display all dates that are the 30 June 2003 and if not then the previous valuation date. I am using the formula as below which is working fine ({ASSDEPRE.DEPRECDATE}) = Date...
  11. acr1

    Depreciation Query Crystal 7.5

    Re prev...sorry Crystal 8.5
  12. acr1

    Depreciation Query Crystal 7.5

    ...- Expected Life in Years..(eg 30) Currently I have a formula in an existing report (not developed by me) as below: ({ASSVALUE.ACQDATE}+ 365 *{ASSVALUE.EXPLIFE} - DateTime (1999,06,30))/365 "Assets that have reached the end of their Life prior to 30/06/1999" While it appears to work I need...
  13. acr1

    Date Formula - Should I use the Absolute (ABS) syntax?

    Hi Ravi Thanks for your reply...but looking at the numerable ways to use DateDiff an example if possible would help.. TIA Angus
  14. acr1

    Date Formula - Should I use the Absolute (ABS) syntax?

    Hi Team I have a formula below that works as I need to find dates greater than one year...but I also need it to calculate when the PURCDATE is greater than the ACQDATE as well.... as i have some PURCDATE fields (1988 - later) and some ACQDATE fields (1975 - earlier) Should I use ABS...
  15. acr1

    Date formula for a Specific Month Crystal 8.0 -&gt;

    Hi All I have a DateTime Field in a front end program that has a oracle db backend.. I want to extract data for a date ..eg (June 2003) from the database using Crystal 8.5 I have tried the 'ToText'...but need to get all entries for a specified month. Any help asap would be appreciated. Thanks...
  16. acr1

    Seagate Info Vs 7.0 Excel print Error

    Hi Team I have the following error generated in a Seagate Info Vs 7 excel report...Can anyone give me an indication of what is causing the problem asap.. &quot;.....When report is exported to excel, when asked to print - Printer tells me bad communication, & I have to override. Printer then...
  17. acr1

    Hi Team I have the following

    Hi Team I have the following error generated in a Seagate Info Vs 7 excel report...Can anyone give me an indication of what is causing the problem asap.. &quot;.....When report is exported to excel, when asked to print - Printer tells me bad communication, & I have to override. Printer then...
  18. acr1

    Access97 Human Resources.mdb sites.?

    Jeremy Thanks for your reply...yes I am aware of the complexities involved. I do have an HR db however the relationship setup is not allowing us to delete old records.. Perhaps I could remove affecting relationships DELETE records then apply relationships again... Thought it would be easier to...
  19. acr1

    Access97 Human Resources.mdb sites.?

    All I am interested in a MSAccess97 db that caters for Human Resources...etc. Unsure whether this is the appropriate medium but if anyone can assist with freeware/shareware solutions without re-inventing the wheel that would be great. TIA acr
  20. acr1

    Seagate Reports Folder Structure

    All We use a copy of Seagate Info (Reports Vs 7) on Citrix with a 50 User license. Can anyone advise if their are any limitations to the number of folders and subfolders that can be setup under the Administrator(for security) and the Desktop. TIA

Part and Inventory Search

Back
Top