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: rpmel
  • Content: Threads
  • Order by date
  1. rpmel

    Access Form: Compare Amount on Main form with Subform

    Ok, Somebody should nail this one fairly fast. I'm kinda new at this and not sure how to go about it. I'm designing my own budgeting database, (a) because I don't like the ones available, and (b) to improve my Access / VBA skills. I have 2 tables: TBL_Transhdr ============ Date Payee Amount...
  2. rpmel

    Crystal / If Then Else / Accpac / Optional Field

    Hi everyone! Crystal XI help please? I have a formula field (LEADTIME) that looks like this, WhileReadingRecords; If {APVENO.OPTFIELD} = "LEADTIME" Then ToNumber ({APVENO.VALUE}) Else 0 The idea being, have a look at the Vendor Record, for an Optional field called “LEADTIME” then, if it...
  3. rpmel

    Previous Function

    I've created a report to calculate suggested stock holding: Using the following example: Part Number ABC123 Leadtime (Days) = 5 Buffer Stock (Days) = 2 Sales per Day = 1 Formula Field setup as follows: Sales x Leadtime + Bufferstock (1 x 5 + 2 = 7) I'm getting 29!!! Here's why: My report...
  4. rpmel

    Summarise on Formula Field

    Hi Everyone! I've created a report to measure leadtime taken from the time a customer places an order, to the time it gets invoiced on dispatch. I've used Ken Hamady's workday formula, and then created another formula field called ONTIME, which looks like this: If {@WORKDAYS} <= Average...
  5. rpmel

    Crystal Reports / Subreport (Newbie)

    Hey everyone, I'm relatively new to Crystal and need some help. I've created a report in Crystal XI, that looks like: Month 1 VENDOR PO # Date Ordered Date Recd Workdays Acme 1234 01/12/2008 03/12/2008 2 The idea being to...

Part and Inventory Search

Back
Top