Search results for query: *

With my tech hat on: it sounds like you want to use Price Codes (I/M, Setup, Price Code maintenance). This allows you to have up to 36 price levels per price code. One price code per item. One price level per customer. It takes creativity to apply it correctly. Work out your ideas in a...

What you are describing has to do with Access. It saves you the hassle of having to re-enter the password. If I understand what you are trying to accomplish, you want to extract data and re-join the muliple companies back into a single table. If so I have done this before. You would want to...

What is "While Printing Records" used for? I have a subreport I am trying to pass a value from. It seems to not pass the value due to the record falling within the last sequence. Detail Records 100-00 pass-through works fine. 100-99 pass-through does NOT work. &ru

You may have missed the subtlety here. Or maybe I am missing the simplicity (but I doubt it). By adding the two fields together, here is the result I get... Table1.ItemNo Table2.ExtDesc Table2.Sequence Details > Record #1 A100ZX Interface, tabl 001 Record #2 A100ZX...

I want to combine extended description fields into one field that shows at the record level. For example... Table1:Inventory Item Table2:Extended description on inventory items Table1.ItemNo Table2.ExtDesc Table2.Sequence Details > Record #1 A100ZX Interface, tabl...

I have a Bill of Lading where I need certain disclaimers to print in the right column. The disclaimer is fixed text and will span a range of details (items shipped). Here is the jist of what the form looks like... QTY ITEM# DESCRIPTION (This is where the 1 ABC ABC PART...

Below is the pattern to follow. I am getting a "5" as a result for 12/29/02 rather than a "1"? And how do I compensate for this? Sunday Saturday Week # 12/29/2002 1/4/2003 1.00 1/5/2003 1/11/2003 2.00 1/12/2003 1/18/2003 3.00 1/19/2003 1/25/2003 4.00...

Both answers have minor flaws in them and I'm not sure they can be corrected using either approach. I am thinking at this point it might be easier to have the user enter a parameter that passes through to the report. Thanks gurus, &ru &ru

I need to strip the slashes from a date field. I have: 1/2/2003 I need: 01022003 &ru

My database has dates in this format: 1/21/2003 10/1/2003 I need these dates to appear in this format: 01212003 mmddyyyy 10012003 mmddyyyy &ru

Thanks, but I need it to tell me what week in the current month it is. And the fiscal year is slightly different than a calendar year. For example, the year starts at 12/29/02 and ends at 12/28/03. Even the months are atypical. Period 1 starts 12/29/02 and ends on 2/2/03. &ru

I need a formula that will return a value for which week the transaction date falls within the current month (1-5). In other words, if the transaction date is 2/3/2003 the result should be "2" since it is based on a Sunday - Saturday week. Another example is if the transaction date...

Looks like it did not work completely. I see the logic in what you were attempting to do with "pagenumber = totalpagecount"; however, these are invoice forms. There may be 20 invoices in a batch. Therefore, the page number may never equal the total page count. Currently, the page...

Thank you so much. Where can I learn these tricks? &ru

Problem: I have a subreport in footer "a" and a large footer in footer "b". When the report exceeds one page, my page footer (where it says, "continued") does not show. I know that the reason for this is that I have a conditional suppress on the page footer...

I have a Bill of Lading that is printing on a dot matrix and need to change the page length to 8 1/2 x 7. Any way to accomplish this? &ru

Why would the following formula return an error? totext({SO_23CRWInvoiceDetail.QtyShipped}/{IM_90_UDF_IM_Masterfile.Weight}) + " " + totext({IM_90_UDF_IM_Masterfile.Label}) When I save the formula in Crystal it does not find an error, yet when I preview the report the error pops up. &ru

This formula will not give a result because I need to specifically search for a piece of text that matches: {Field A} = "MARFIM ANTARTIDA QTR RND" For "QTR RND" in that text. So IF "QTR RND" exists anywhere in {Field A} THEN "SBN & QTR RND" Is there...

I want to create a group and then gather records into that group based on the contents of a certain field. IF {Field A} contains "SBN" OR "QTR" THEN gather record into GROUP A. ELSE IF {Field A} contains "DA" OR "BEAK" gather record into GROUP B. My...

I get errors with what you gave. Maybe I misunderstood. Do you mean to place those formulas inside my existing formula somewhere? &ru