Search results for query: *

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

Well, the field is an optional field, added to each supplier record manually - it doesn't actually exist by default until you add it in as an optional field. Hmm, might actually need to refer this to our external Accpac dude for some help I think? The value is set as Uppercase and selected by...

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

Thanks lbass - works a treat ;)

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

Thanks IdoMillet, Can you please give me some help? How do I do that? I've only been messing around in Crystal for a week. I'm using Crystal XI.

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

Never mind! All sorted! Not sure how I did it, otherwise I'd tell...

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