Query?

[Jlok]

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!

 

[VicRauch]

If you only want the first instance, I'm assuming there is a date involved. Therefore, you would need a summary query where you would group on UPS tracking number and select the date that is Minimum.

If you want any other options on how to do this, just ask as there is a least one other method.

 

[Jlok]

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.

 

[PHV]

How do you distinguish the 2 or more entries ?
how do you know which is the first instance ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Jlok]

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-

 

[PHV]

Have a look at the DISTINCT predicate.
Another way is to play with an aggregate query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Jlok]

DISTINCT worked great! Thanks for the tip!