Recent content by Jlok

Here it is.... http://www.locksmithstore.com/packing%20slip.rpt Thanks-

Can I upload the report here?

I'll try to clarify... This report is our packing slip from our accounting software. Currerntly the form prints as the items were entered in our application. We want the packing slip to sort by description instead of the way it was entered. I tried adding a simple sort order by description and...

Hello, Need help adding a sort order to a group header. Currently the group header is set to Temp.Order.Header.Number. I need to keep this in place while also adding a sort by description.

DISTINCT worked great! Thanks for the tip!

This is the problem! The UPS export feature is nice but surely lacking. You don't know which is the first. I dont care which I display in the query just that I only display 1. I dont think what I am asking for is possible but figured I'd ask anyway-

No date involved. Just an order number and tracking number thats it. Sometimes if a package is modified the UPS program will re-write to the table a second time. This is where it is becoming a problem.

I have a table for UPS tracking numbers and could possibly contain 2 or more entries with the same tracking number. Is it possible to write a query that would only show the first instance? I use this field on a crystal form and if it contains multiple tracking numbers it screws up the form. Thanks!

LB, That was it! Man, I can't thank you enough.... I tried everything.... Except the stupid join type! Thanks Again!!

It's not that the table is blank. The table does not exist if it is empty. Well it exists, but there is no entry for that order number. So, how do I write a formula to tell it to skip if it does not exist?

Tried all that.... Pulling my hair out on this one. Lets start from the top (If you dont mind :)) Btrieve database, Invoice form. Form prints fine when these fields are removed from the form. When fields are present with no value forms comes up blank. I have tried every suppression formula...

Thank you- if {TEMP_ORDER_HEADER.BVSUBTOTAL} > 100 then IDAutomationFontEncoderCode128 ({TEMP_ORDER_HEADER.NUMBER} & totext({TEMP_ORDER_HEADER.BVSUBTOTAL},0),0 ) else IDAutomationFontEncoderCode128 ({TEMP_ORDER_HEADER.NUMBER},0) That did it!

This is what I got, It is a formula for a barcode if {TEMP_ORDER_HEADER.BVSUBTOTAL} > 100 then IDAutomationFontEncoderCode128 ({TEMP_ORDER_HEADER.NUMBER} & {TEMP_ORDER_HEADER.BVSUBTOTAL},0 ) else IDAutomationFontEncoderCode128 ({TEMP_ORDER_HEADER.NUMBER},0) I need for...

I tried INT({table.field}) it returned 12300 instead of 123.50 Looking to get 123

Trying to use truncate to return a whole number... TRUNCATE ({field}) What am I doing wrong? Table contains order values. All entries have a 2 place decimal 123.45 I want to return 123?? What am I missing? Thanks-